Skip to content

Registered aircraft · 20,681

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.

N13391Brazos Valley Flight Services LLC · College Station, TXBuilt 1973 · S/N 17262723 N13394Ck Leasing Services LLC · Wilmington, DEBuilt 1973 · S/N 17262725 N13399Great Plains Spraying Inc · Colby, KSBuilt 1973 · S/N 17262729 N1339FFriedlander Edward R · Hattiesburg, MSBuilt 1966 · S/N 17254834 N1339YMiller Henry C · Mckinney, TXS/N 17249039 N133AJAmerican Patrols Inc · Midland, TXBuilt 1986 · S/N 17276614 N133CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 172S12131 N133VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281190 N13400Opolka John G · Midlothian, TXBuilt 1973 · S/N 17262730 N13402Cartwright Edward N · Winterville, NCBuilt 1973 · S/N 17262731 N13404Kroner David S · Rock Creek, OHBuilt 1973 · S/N 17262733 N13405Kelley Aircraft LLC · Weyers Cave, VABuilt 1973 · S/N 17262734 N13406Shore Stephen A · Thurmond, NCS/N 17262735 N1340YStephens Christopher L · Kelso, WAS/N 17249040 N1341FDix Justin T · South Boston, VABuilt 1966 · S/N 17254836 N1341YLong Gary A · Lewisport, KYBuilt 1962 · S/N 17249041 N13426Sardeson Ronald L · Greenwood, NEBuilt 1973 · S/N 17262744 N13429Mercado Carlos · San Juan, PRBuilt 1973 · S/N 17262746 N1342FFriedman Peter Michael · Pleasant Hill, CABuilt 1966 · S/N 17254837 N13431Kelly William W · Springfield, ORBuilt 1973 · S/N 17262748 N13435Torres Debra A · El Paso, TXBuilt 1973 · S/N 17262749 N13437Dyberg Michael DBA · Mount Vernon, WABuilt 1973 · S/N 17262751 N13445Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1973 · S/N 17262756 N13447Vessichelli Ryan A · Virginia Beach, VABuilt 1973 · S/N 17262757 N13450Wilkes Flying Club Inc · Wilkesboro, NCBuilt 1973 · S/N 17262760 N13451Kostman Cody J · Bingham, NEBuilt 1973 · S/N 17262761 N13452Butler Shane M · Russellville, ARBuilt 1973 · S/N 17262762 N13456Johnson Richard A · Chandler, AZBuilt 1973 · S/N 17262766 N1345YFlying Horse LLC · Missoula, MTBuilt 1961 · S/N 17249045 N13460Robinson Doyle K · Panhandle, TXS/N 17262767 N13461Aero Maintenance Inc · Vancouver, WABuilt 1973 · S/N 17262768 N13464Seal Charles Kevin · Luray, VABuilt 1973 · S/N 17262770 N13465Mach III Flying Inc · Platte City, MOBuilt 1973 · S/N 17262771 N13469Angels Over Atlanta Inc · Fayetteville, GABuilt 1973 · S/N 17262773 N1346EMonillas Peter C · Martinez, CABuilt 1978 · S/N 17270964 N13475Wisk Aero LLC · Mountain View, CABuilt 1973 · S/N 17262778 N13479Hendricks Field Aviation LLC · Sebring, FLBuilt 1973 · S/N 17262781 N1347FSprague Lee G · Augusta, GABuilt 1966 · S/N 17254842 N13481Moreland David W · Fort Payne, ALBuilt 1973 · S/N 17262783 N13483Walk Michael · Englewood, FLFirst renewal noticeBuilt 1973 · S/N 17262784 N13486Anderson Joel M · Starkweather, NDBuilt 1973 · S/N 17262787 N13489Baby Balou Flyers LLC · Marysville, WABuilt 1973 · S/N 17262789 N1348FRau Bodo A · Aliso Viejo, CABuilt 1966 · S/N 17254843 N1348LFlight World Inc · San Juan, PRBuilt 2005 · S/N 172S9939 N1348YCoughlin Patrick J · Nashua, NHBuilt 1961 · S/N 17249048 N13492Hausteen Karen Grace · New River, AZBuilt 1973 · S/N 17262790 N13494Landry Jeremy · Thibodaux, LABuilt 1973 · S/N 17262792 N1349FTran Holm Viet · Henderson, NVS/N 17254844 N1349YSheehan Michael F · Avalon, CABuilt 1961 · S/N 17249049 N134BChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9345

Back to AD 90-06-03 R1