Skip to content

Registered aircraft · 1,578

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:72-14-08-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:72-14-08-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:72-14-08-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:72-14-08-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:72-14-08-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:72-14-08-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.

N1121QTwomey Kieran S · Coronado, CABuilt 1963 · S/N 310H0121 N11220Southern Arkansas University Tech · Camden, ARBuilt 1957 · S/N 38037 N1129QTippecanoe Valley Aero Inc · Delphi, INBuilt 1963 · S/N 310H0129 N112HPBertagnole Karl R · Wright, WYBuilt 1964 · S/N 310I0104 N112HRFlexer Howard · Monterey Park, CAS/N 35217 N1133QHaggard Haley G · Springer, OKBuilt 1963 · S/N 310H0133 N114HVAerowerks LLC · Georgetown, TXBuilt 1973 · S/N 421B0371 N115CKSchmick Kenneth R · Fond Du Lac, WIS/N 35281 N116BGGood Bill T · Temecula, CABuilt 1955 · S/N 35116 N117JDVintage Motors Inc · Beattyville, KYBuilt 1967 · S/N 310L-0167 N117KZRichards Robert · Waco, TXS/N 310Q0964 N117TCChristensen Del S · Friendswood, TXBuilt 1973 · S/N 310Q0786 N117WWNowak Jerome S · Elmhurst, ILS/N 320D0096 N1181FPatel Jayesh V · Titusville, FLBuilt 1959 · S/N 35971 N1188Persky Adam · New Bern, NCBuilt 1960 · S/N 39152 N1189MQuality Aviation Inc · Marana, AZS/N 39180 N119PARicciardi Brian P · Hyannis, MAS/N 402B0610 N11DEPeile Kelly · Lakeview, ORS/N 38087 N11SLJohnson Randy L · Pikeville, KYBuilt 1960 · S/N 310-0029 N1202GTyler Brenda · Mountain Top, PABuilt 1974 · S/N 310Q1057 N1205GKnapp James Ross · Apex, NCBuilt 1974 · S/N 310Q1060 N12144Pittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1958 · S/N 31038118 N121DRJohnson And Son Enterprises · Dunn, NCBuilt 1974 · S/N 310Q1046 N121LATgl Inc · Wilmington, DEBuilt 1973 · S/N 310Q0973 N1223HS&S Leasing Solutions LLC · Sandy Springs, GABuilt 1973 · S/N 421B0365 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 N122SWAmerican Petroleum Corp · Ratliff City, OKS/N 421B0506 N123BTYingling Consultation LLC · Wilmington, DEBuilt 1973 · S/N 421B0414 N123CWCoastal Wings LLC · Fort Lauderdale, FLS/N 310Q0975 N123DEGearhart John D · Arlington, WAS/N 35926 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 N124WC3-B Farms Inc · Pinetown, NCBuilt 1973 · S/N 421B0484 N1258GConroy Bruce M · Martinez, CABuilt 1974 · S/N 310Q1109 N125DMCallegari Gino A · Susanville, CABuilt 1966 · S/N 310K0176 N125ETGrindeland Ethan P · Hatton, NDBuilt 1958 · S/N 35706 N1267GChesnut James Scott · Oak Point, TXBuilt 1974 · S/N 310Q1118 N1271GSee Christopher · Owenton, KYS/N 310Q1122 N1276GCarter Joseph C · Brookline, NHBuilt 1974 · S/N 310Q1126 N1279GHodgman Gary W · Greenville, TXBuilt 1974 · S/N 310Q1129 N1292GBahig Saliba · Scottsdale, AZBuilt 1974 · S/N 310Q1141 N1293VEgmond Aircraft LLC · Lewes, DES/N 310Q1038 N129CMWoodhaven Air LLC · Blue Springs, MOBuilt 1958 · S/N 35625 N129DPSplendid Air Leasing LLC · Corpus Christi, TXS/N 310L-0006 N12CYYeagle Aviation Inc · Port Saint Lucie, FLBuilt 1971 · S/N 310Q0247 N12KNJane Air LLC · Kalamazoo, MIBuilt 1968 · S/N 421-0130

Back to AD 72-14-08 R1