Registered aircraft · 5,086

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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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.

N114TLLa Soplaera Realty LLC · Niwot, COBuilt 2003 · S/N T18208220 N1151ZRenfro Michael W · Bethel, AKS/N 1524-186 N1154XKelley Jay D · Lake Havasu City, AZS/N 32-7540149 N1157SDig2fly LLC · Sandpoint, IDBuilt 1978 · S/N 317812093 N115GTWahl John H · Rockwell City, IAS/N 20042 N115JDC R Aviation Inc · Miami, FLS/N 27-7405395 N115KTMulva Jonathan · De Pere, WIBuilt 2002 · S/N 20044 N115MDSpecial Orthogonal Group LLC · Dover, DEBuilt 2001 · S/N 20039 N115SZThree Greens LLC · San Jose, CABuilt 2000 · S/N 20036 N1165XLechtenberg Lance · El Dorado, KSBuilt 1975 · S/N 32-7540150 N116GWMajestic Airlines Inc DBA · Lynden, WABuilt 1970 · S/N 31-662 N116MFWeber Donald E · Saint David, AZS/N 27-3522 N116RCMiesch Gary D · Gowen, MIBuilt 1976 · S/N 14061 N116SMArchie Aero LLC · Beaverton, ORBuilt 2005 · S/N T18208426 N1176ZAirborne Support Inc · Bourg, LABuilt 1965 · S/N 500-B-1549-196 N117BMManeck Aviation LLC · Columbus, GABuilt 1997 · S/N 46-36078 N117GHAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2001 · S/N 3257217 N117KRFox Planes LLC · Sterling Heights, MIBuilt 1997 · S/N 4636088 N117SEHalsell Jason · Wolfforth, TXBuilt 2004 · S/N 3255017 N117TDGiffin Craig D · Windermere, FLBuilt 1990 · S/N 27-0074 N1180XK & K Aero Inc · Wilmington, DEBuilt 1975 · S/N 32-7540152 N118ESCmv Aviation LLC · Johnson City, NYBuilt 1976 · S/N 32R-7680374 N118JGRopewalk Investments LLC · Wilmington, DEBuilt 1995 · S/N 4622187 N119GSDall James R Jr · Hayes, VABuilt 1985 · S/N 32R-8529009 N119KRc Stone LLC · Willacoochee, GABuilt 2004 · S/N T18208232 N11BHHarbold Norris Brown Jr · Lake Wylie, SCBuilt 1996 · S/N 27 N11CGComanche 260b-N11cg · Pomeroy, WABuilt 1966 · S/N 24-4434 N11KXN11kx LLC · Santa Clara, CABuilt 1981 · S/N 32-8224004 N11LJHandyquick Mn LLC · Woodbury, MNBuilt 2004 · S/N T20608485 N11MPAtwill Brock · Paragould, ARBuilt 1972 · S/N 27-4821 N11PZCentral Virginia Flyers LLC · Palmyra, VABuilt 1971 · S/N 27-4699 N11UTMax Aviation LLC · Venice, FLBuilt 1967 · S/N 31-116 N1204CCarvilles Auto Mart · Grand Junction, COBuilt 2001 · S/N T18208026 N120DGBluesail LLC · Las Vegas, NVBuilt 1981 · S/N 32R-8129077 N120DMWestfall Aviation LLC · Reno, OHBuilt 1973 · S/N 32-7340122 N120FWRaabe Travel LLC Series 1 · Whitehouse, TXBuilt 1998 · S/N 4636134 N120JDLamb Aviation LLC · Perris, CABuilt 1981 · S/N 31-8152179 N120LPGramer Air IV LLC · Northville, MIBuilt 1977 · S/N 31-7812010 N120MLMrl Aviation LLC · Wilmington, DEBuilt 1977 · S/N 31-7752091 N1218WOndrick Aviation LLC · Chicopee, MABuilt 2003 · S/N 3255006 N121GHSunset Aviation LLC · Huntington, INBuilt 1977 · S/N 32R-7780262 N121SLLadet David E · Lavonia, GABuilt 1969 · S/N 27-4475 N121SPFl280 LLC · Deland, FLBuilt 1960 · S/N 500B-984-25 N121TDelmarva Flight Leasing Inc · East Moriches, NYBuilt 1992 · S/N 270124 N121TFTorres Juan · Modesto, CABuilt 2004 · S/N 3257351 N121TWBlue Ridge Mountain Flyers Aviation LLC · Mineral Bluff, GABuilt 1977 · S/N 32R-7780301 N1222ZFord Carol C Jr · Canyon Country, CAS/N 61-0070-129 N1224TAig Aeronautics LLC · Guaynabo, PRBuilt 1999 · S/N 32-57116 N122AWAztec Worldwide Airlines Inc · Wilmington, DEBuilt 1976 · S/N 31-7652135 N122JPZatika Francis · Bridgewater, NJBuilt 1978 · S/N 61P-0535227

Back to AD 91-21-01 R1