Skip to content

Registered aircraft · 40,396

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N733TDFrantzen Elizabeth · Davie, FLBuilt 1976 · S/N 17267136 N733TERedtail Partners LLC · Moab, UTBuilt 1977 · S/N 17268529 N733TJFenton Earl · Puyallup, WABuilt 1977 · S/N 17268533 N733TKCardiff Aviation Inc · Cardiff By The Sea, CABuilt 1977 · S/N 17268534 N733TLRising Wings Aviation Inc · Casper, WYBuilt 1977 · S/N 17268535 N733TPR&R Aero Services LLC · Eden Prairie, MNBuilt 1977 · S/N 17268538 N733TQCarmel Aviation Inc · Boise, IDBuilt 1977 · S/N 17268539 N733TRWenatchee Sport Flyers · Wenatchee, WABuilt 1977 · S/N 17268540 N733TSCox Eileen Xiomara · Davie, FLBuilt 1977 · S/N 17268541 N733TTTeens In Flight Inc · Palm Coast, FLBuilt 1977 · S/N 17268542 N733TVTempleton Bros Construction LLC · Livingston, TXBuilt 1977 · S/N 17268544 N733TXKelley Aircraft LLC · Weyers Cave, VABuilt 1977 · S/N 17268545 N733UAMergen John F · Baltimore, MDBuilt 1977 · S/N 17268548 N733UBKale Larry · Rogers, OHBuilt 1977 · S/N 17268549 N733UCSorbi Aviation Inc · El Cajon, CABuilt 1977 · S/N 17268550 N733UDSpinks Flight Center Inc · Burleson, TXBuilt 1977 · S/N 17268551 N733UFReid Dennis · Vinemont, ALBuilt 1977 · S/N 17268553 N733UGHoffman Thomas A Trustee · Emmett, KSBuilt 1977 · S/N 17268554 N733UJEngelhard Edward L · Hatfield, PABuilt 1977 · S/N 17268556 N733UTOmartian Robert A · Simsbury, CTBuilt 1977 · S/N 17268565 N733VADrane Kenneth · Natchez, MSBuilt 1977 · S/N 17268572 N733VFGillen Scott E · San Diego, CABuilt 1977 · S/N 17268577 N733VGFrevert Darwin C · Highland Village, TXBuilt 1977 · S/N 17268578 N733VHAerospace Testing Engineering & Certification Inc · Seattle, WABuilt 1977 · S/N 17268579 N733VJLura Aaron P · Carrington, NDBuilt 1977 · S/N 17268580 N733VLYuma Ag Service Inc · Yuma, COBuilt 1977 · S/N 17268582 N733VRLegends Air Center LLC · Bentonville, ARBuilt 1977 · S/N 17268587 N733VSClemson Flying Club Inc · Seneca, SCBuilt 1977 · S/N 17268588 N733WCDrouin Roger R · Naples, FLBuilt 1977 · S/N 17268598 N733WEAirwaves Nsb LLC · New Smyrna Beach, FLBuilt 1977 · S/N 17268600 N733WGMiloud Chad · Fort Worth, TXBuilt 1977 · S/N 17268602 N733WHFritts Paul D · Southworth, WABuilt 1977 · S/N 17268603 N733WLShadduck James N · Annandale, MNS/N 17268606 N733WMNakamura Hajime Trustee · Long Beach, CABuilt 1977 · S/N 17268607 N733WSAirgo Inc · Centralia, ILBuilt 1977 · S/N 17268612 N733WTAnderson Aviation Services Inc · Carlsbad, CABuilt 1977 · S/N 17268613 N733WUAviator Air Flight School LLC · Grand Prairie, TXBuilt 1977 · S/N 17268614 N733WVRatzlaff Jeff DBA · Langdon, NDBuilt 1977 · S/N 17268615 N733WWFm Aviation Inc · Concord, CABuilt 1977 · S/N 17268616 N733WXSpartan Marine Co · Capistrano Beach, CAS/N 17268617 N733WYFlys And Floats C172 LLC · Panama City Beach, FLS/N 17268618 N733XBBlair Burkholder Inc · Erie, COBuilt 1977 · S/N 17268621 N733XEAeroventures Flying Club Inc · Lilburn, GABuilt 1978 · S/N 17268624 N733XFBeaugez Gregory C · Perkinston, MSBuilt 1977 · S/N 17268625 N733XKSabol Edward J Trustee · Leominster, MABuilt 1977 · S/N 17268629 N733XLAirspeed Marketing LLC · Phoenix, AZBuilt 1977 · S/N 17268630 N733XMRoatis Calin V · Sacramento, CAS/N 17268631 N733XNFlyn Go LLC · Spring, TXBuilt 1977 · S/N 17268632 N733XZ3650 Aircraft Inc · Bakersfield, CABuilt 1977 · S/N 17268643 N733YBZulu Aerospace Services LLC · Peoria, AZBuilt 1977 · S/N 17268645

Back to AD 79-10-03 R2