Skip to content

Registered aircraft · 54,015

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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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.

N7405XWills Terry W · Cedar Park, TXBuilt 1961 · S/N 17247905 N7407AKremmling Flying Inc · Kremmling, COS/N 29507 N7407GStarr Ralph H · Port Orange, FLBuilt 1973 · S/N 15074654 N7408AJohnston Lynwood A · Anchorage, AKS/N 29508 N7409EDavis Julius E · Theodore, ALS/N 57109 N7409GAero Quest LLC D/B/A · Olive Branch, MSBuilt 1970 · S/N 17259109 N7409TJohnson Scott E · Wausau, WIS/N 47009 N740BBellas Business LLC · Kalispell, MTS/N 57282 N740BHHarris Jaqai · Juneau, AKBuilt 1955 · S/N 31348 N740MHumphrey William A · Grosse Ile, MIBuilt 1965 · S/N 337-0160 N740SBirch Tree Aviation LLC · Unadilla, GABuilt 1969 · S/N 33701221 N7410EFerguson Thomas H · Springfield, MOBuilt 1960 · S/N 57110 N7410TLepinsky Donald J · Whitehall, MTBuilt 1959 · S/N 47010 N7411ACoverdill Robert E · Savoy, ILBuilt 1956 · S/N 29511 N7411ERenshaw Elliott · Lavernia, TXBuilt 1960 · S/N 57111 N7411TMcbain Sarah R · West Warwick, RIBuilt 1959 · S/N 47011 N7411XTakagi Mark A · Richland, WABuilt 1960 · S/N 17247911 N7412ELorraine Aviation LLC · Lewes, DEBuilt 1960 · S/N 57112 N7412QTrostad Kari L · Minnetrista, MNBuilt 1972 · S/N 18261052 N7412SClear Blue Aviation LLC · Hayden, IDBuilt 1976 · S/N 18265192 N7412TDavis Tonya · Hohenwald, TNBuilt 1959 · S/N 47012 N7412XEpperson Gregory R · Grove, OKBuilt 1960 · S/N 17247912 N7413QMccullough Alfonzo F · Aurora, COBuilt 1972 · S/N 18261053 N7413TThompson Daniel L · Malta, OHBuilt 1959 · S/N 47013 N7414AMutter Wilson T · Chelan, WABuilt 1956 · S/N 29514 N7414MFrenzel Carl O · Midlothian, TXBuilt 1959 · S/N 55714 N74150Meyer Tabatha M · Fairview, TXBuilt 1973 · S/N 15074538 N7415ASmith Kevin L · Peachtree City, GABuilt 1956 · S/N 29515 N7415KClarke Kenneth J · Anchorage, AKS/N 17259115 N7415XKeenan James F · Neenah, WIBuilt 1960 · S/N 17247915 N7416AAce Flying Co LLC · Wichita, KSBuilt 1956 · S/N 29516 N7416GDreggors David Richard · Altamonte Springs, FLBuilt 1970 · S/N 17259116 N7416QRobin Alan Olmstead · Yuma, AZBuilt 1972 · S/N 18261056 N7416TMcalister Donald F Jr · Munith, MIBuilt 1959 · S/N 47016 N7416XHarris Terrence J · Killeen, TXBuilt 1960 · S/N 17247916 N74177Campbell Peter Shane · Knoxville, TNBuilt 1974 · S/N 177RG0481 N7417AKoons Bill R · Centerville, MOBuilt 1956 · S/N 29517 N7417TMcgrath William F Jr · Nantucket, MABuilt 1959 · S/N 47017 N7417XNix Renford R · Lake Village, ARBuilt 1960 · S/N 17247917 N7418TDavis Larry M · Waleska, GABuilt 1959 · S/N 47018 N7419ACliff Lloyd B · Hemet, CABuilt 1957 · S/N 29519 N7419GFlycarolina LLC · Concord, NCBuilt 1970 · S/N 17259119 N7419MStepp William F III · Williamsport, PABuilt 1959 · S/N 55719 N7419TIntellipix LLC · Cambridge, MDBuilt 1959 · S/N 47019 N7419XSkyranch Knoxville Youth Inc · Knoxville, TNBuilt 1960 · S/N 17247919 N741DJBruce David Alan · Jupiter, FLBuilt 1979 · S/N R1723084 N741DPPleasant Aviation LLC · Mount Pleasant, TXBuilt 1974 · S/N 17264611 N741GSReform Friendly Flyers LLC · Buhl, ALBuilt 1970 · S/N 17259111 N741MWatts Scott E · Auke Bay, AKBuilt 1965 · S/N 18051639 N74206Chinn Larry · Anatone, WABuilt 1974 · S/N U20602457

Back to AD 87-20-03 R2