Skip to content

Registered aircraft · 20,683

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:90-06-03-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1') 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:90-06-03-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1')
  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:90-06-03-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1')
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.

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 N733XDRoadrunner Bus LLC · Weston, NES/N 17268623 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 N733XXHann Bruce E · Athens, OHS/N 17268641 N733XYRuss Micheal · Greer, SCS/N 17268642 N733XZ3650 Aircraft Inc · Bakersfield, CABuilt 1977 · S/N 17268643 N733YBZulu Aerospace Services LLC · Peoria, AZBuilt 1977 · S/N 17268645 N733YCWings Over Texas Holdings LLC · Denton, TXS/N 17268646 N733YEDiederich Fred H · Fayette City, PABuilt 1977 · S/N 17268648 N733YGLeaschauer Eitan · San Jose, CABuilt 1977 · S/N 17268650 N733YHBailey Gordon J · Fayetteville, GABuilt 1977 · S/N 17268651 N733YKLdac Properties LLC · Fresno, CAS/N 17268653 N733YPMiller Robert · Battle Creek, MIBuilt 1977 · S/N 17268657 N733YRBoccaccio Donald O · Hypoluxo, FLBuilt 1977 · S/N 17268659 N733YTRegistration Pending · Centereach, NYRegistration pendingBuilt 1977 · S/N 17268661 N733YVSluka Christopher J · San Diego, CAS/N 17268663 N733YYTetrault Howard D · Malabar, FLBuilt 1977 · S/N 17268666 N733YZSeaplane Adventures LLC · Cheyenne, WYBuilt 1977 · S/N 17268667 N733ZAWanda Collins Professional Pilot Services LLC · Madisonville, TXS/N 17268668 N733ZBMidstate Aviation 1 LLC · Owosso, MIBuilt 1977 · S/N 17268669 N733ZEKgr Aviation LLC · Austin, TXBuilt 1977 · S/N 17268672 N733ZGContreras Shelly · Tracy, CAS/N 17268674 N733ZKStone Aviation LLC · Sacramento, CABuilt 1977 · S/N 17268677 N733ZNAtmospheric Vehicle & Spacecraft Flt Exploration · Rch Palos Vrd, CABuilt 1977 · S/N 17268680 N733ZPFruit Belt Flyers Inc · Saint Joseph, MIBuilt 1977 · S/N 17268681 N733ZSMccown Jamey · Bayfield, COBuilt 1977 · S/N 17268684 N733ZYHess Garrett J · Fullerton, CAS/N 17268690 N733ZZDuncan James · La Porte, TXBuilt 1977 · S/N 17268691 N73401Sage Kathlene A · Bass River, MABuilt 1976 · S/N 17267431 N73407Wxly Aviat LLC · Gastonia, NCBuilt 1976 · S/N 17267435 N73411Elwood James C · Jupiter, FLBuilt 1976 · S/N 17267438 N73419Cook Thomas M · Palmer, AKBuilt 1976 · S/N 17267443 N7341GHolmes Omer Lane Jr · Metairie, LABuilt 1970 · S/N 17259041 N7341TG & D Holdings LLC · Provo, UTS/N 46941 N73420Globemaster Services LLC · Saint Jacob, ILBuilt 1976 · S/N 17267444 N73423Weck Geoffrey E · Woodstock, ILBuilt 1976 · S/N 17267447 N73424Quincy Flying Club Inc · Quincy, ILBuilt 1976 · S/N 17267448 N73425Wings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267449 N73428Johnson Brent C · Appleton, MNBuilt 1976 · S/N 17267452 N73429Anson Flyers Club Inc · Wadesboro, NCBuilt 1976 · S/N 17267453

Back to AD 90-06-03 R1