Skip to content

Registered aircraft · 828

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

N100ELLeading Edge Leasing LLC · Wilmington, DES/N 310Q-0688 N100JHSonic Aviation LLC · Carrollton, MSBuilt 1971 · S/N 310Q0421 N100TGBengtson Todd · Tyler, TXBuilt 1974 · S/N 310Q1150 N103EMSjm Aero LLC · Winter Haven, FLS/N 310R0083 N103FSHannah Lonnie · Williamson, WVBuilt 1979 · S/N 310R1834 N103RMValiair Lc Trustee · Casper, WYBuilt 1975 · S/N 310R0109 N105CWStone George Michael Jr Trustee · Weeki Wachee, FLBuilt 1974 · S/N 310Q-0936 N107TTBpi Labs Inc · Evanston, WYBuilt 1978 · S/N 310R1345 N10BDCalkins Mark E · Longview, TXBuilt 1978 · S/N 310R1539 N10ETTech Nav LLC · Columbus, INBuilt 1971 · S/N 310Q0415 N10FCKnott Me LLC · Phoenix, AZBuilt 1973 · S/N 310Q0796 N110CSFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1972 · S/N 310Q0616 N111EAExecutive Air Inc · Roanoke, VAS/N 310R0245 N111NCDaxair Aviation LLC · Scottsdale, AZBuilt 1975 · S/N 310R0182 N112WWAmerican Smooth Aviation LLC · Rock Hill, SCBuilt 1977 · S/N 310R1215 N113KKolstad Christopher Van · Galata, MTBuilt 1975 · S/N 310R0107 N114AMLon Air LLC · Longwood, FLBuilt 1977 · S/N 310R0887 N117KZRichards Robert · Waco, TXS/N 310Q0964 N117TCChristensen Del S · Friendswood, TXBuilt 1973 · S/N 310Q0786 N11GXWestrum Enterprises LLC · Norwalk, IABuilt 1976 · S/N 310R0645 N11TJKubic Daniel W · Advance, NCBuilt 1979 · S/N 310R1683 N1202GTyler Brenda · Mountain Top, PABuilt 1974 · S/N 310Q1057 N1203WPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1980 · S/N 310R-2106 N1205GKnapp James Ross · Apex, NCBuilt 1974 · S/N 310Q1060 N121BKSeabee Training Corp · Birmingham, ALBuilt 1977 · S/N 310R0893 N121DRJohnson And Son Enterprises · Dunn, NCBuilt 1974 · S/N 310Q1046 N121LATgl Inc · Wilmington, DEBuilt 1973 · S/N 310Q0973 N1228GMcdaniel Dean K · Mesa, AZBuilt 1974 · S/N 310Q1081 N122AMHarper David · New Richmond, WIBuilt 1973 · S/N 310Q0943 N122EOne Two Two Echo Aviation LLC · Cincinnati, OHBuilt 1973 · S/N 310Q0984 N122SBCessna Twin Flyers LLC · Calhoun, TNS/N 310R0873 N123CWCoastal Wings LLC · Fort Lauderdale, FLS/N 310Q0975 N123MNFoster Aviation And Mobile Maintenance LLC · Dublin, VABuilt 1972 · S/N 310Q0602 N1240GBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 310Q1091 N1242GHeathington A H · Georgetown, TXBuilt 1974 · S/N 310Q1093 N1247GNafziger Aviation Leasing LLC · Wittman, MDBuilt 1974 · S/N 310Q1098 N124DPBaja Air LLC · Wilmington, DEBuilt 1979 · S/N 310R1670 N1258GConroy Bruce M · Martinez, CABuilt 1974 · S/N 310Q1109 N1267GChesnut James Scott · Oak Point, TXBuilt 1974 · S/N 310Q1118 N126TMFlynfish Air LLC · Rome, GAS/N 310R1231 N1271GSee Christopher · Owenton, KYS/N 310Q1122 N1274GSol Aerial Surveys LLC · Las Vegas, NVBuilt 1974 · S/N 310R0001 N1276GCarter Joseph C · Brookline, NHBuilt 1974 · S/N 310Q1126 N1279GHodgman Gary W · Greenville, TXBuilt 1974 · S/N 310Q1129 N127MBBerger Max · Daytona Beach, FLBuilt 1976 · S/N 310R0654 N1280GSky Aviation And Consulting · Panorama City, CABuilt 1976 · S/N 310R0692 N1292GBahig Saliba · Scottsdale, AZBuilt 1974 · S/N 310Q1141 N1293VEgmond Aircraft LLC · Lewes, DES/N 310Q1038 N1296GAir Dogs LLC · Watford City, NDBuilt 1976 · S/N 310R0698 N1297GPilot Mountain Aviation LLC · Marietta, OHBuilt 1974 · S/N 310R0003

Back to AD 75-23-07