Registered aircraft · 2,131

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:2009-13-06-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:2009-13-06-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:2009-13-06-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:2009-13-06-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:2009-13-06-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:2009-13-06-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.

N21ABAriel J Quintela LLC · Odessa, FLBuilt 1980 · S/N 31-8052122 N21AQCapiga Daniel P · North Fort Myers, FLBuilt 1973 · S/N 27-7305035 N21DPPacific Fleet Aviation LLC · Rochester, NYBuilt 1978 · S/N 27-7854097 N21HGDrisco LLC · Ponca City, OKBuilt 1981 · S/N 31-8152078 N21HLChieftain Aviation Inc · Marietta, GAS/N 31-8152126 N21NCBearing Tree Land Surveying LLC · Oklahoma City, OKBuilt 1976 · S/N 27-7654012 N2202PMacair Aviation LLC · Xenia, OHBuilt 1956 · S/N 23-812 N2209PRuppel Robert E Jr · New Orleans, LABuilt 1967 · S/N 27-3788 N2212PHollingshead Terry L · Flint, MIS/N 23-821 N2214PMaslen Holbrook · Caldwell, IDS/N 23-823 N221ACAusten Air LLC · Lees Summit, MOBuilt 1980 · S/N 31-8152045 N2221PHardin John M · Terrell, TXS/N 23-830 N222DUCg 340 LLC · Fountain Hills, AZBuilt 1973 · S/N 27-7305046 N222EWGuzman Steven M · Port Saint Lucie, FLS/N 23-1539 N222GWDodson International Parts Inc · Rantoul, KSS/N 31T-7904050 N222KHPavco Inc · Gig Harbor, WABuilt 1973 · S/N 27-7305097 N222UClukey David Alan · Bryant Pond, MEBuilt 1957 · S/N 23-912 N222WBPower Robert R · Brenham, TXBuilt 1968 · S/N 27-3992 N2233PAeroplanes Over Idaho · Caldwell, IDS/N 23-842 N2236PCitation X Parts LLC · Liberty, NCBuilt 1956 · S/N 23-845 N2239PCumbee Danny A · Geneva, ALS/N 23-848 N223DAAerodrome LLC · Louisville, KYBuilt 1970 · S/N 27-4563 N2240PAnderson Timothy H · Janesville, WIBuilt 1956 · S/N 23-849 N2244PIsland Birds Inc · St Thomas, VIS/N 27-7405256 N2254PTamayo Alejandro S · San Luis, AZBuilt 1957 · S/N 23-864 N225CATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1981 · S/N 31T-8104024 N225HMSmithart Eric W · San Juan, PRBuilt 1963 · S/N 27-2341 N225MBCheyenne III Flyers LLC · New York, NYBuilt 1983 · S/N 42-8001102 N225PTCurry Construction Inc · Mattoon, ILBuilt 1981 · S/N 31T-8166032 N225TMSouth Of Snow Adventures LLC · Hartwell, GAS/N 318152165 N2260PToliver David R · Overland Park, KSBuilt 1957 · S/N 23-870 N2271PHorton Christian J · Melbourne Beach, FLBuilt 1957 · S/N 23-881 N227AKHanzawa George K · Wahiawa, HIBuilt 1981 · S/N 31-8152198 N227CARa Procurement LLC · Helena, MTS/N 27-4591 N227ECEcjet Inc · Downey, CABuilt 1974 · S/N 31-7405184 N227RGLearn To Fly In Central Arkansas LLC · Searcy, ARBuilt 1974 · S/N 27-7554021 N227RMHeli Coral Inc · Wilmington, DEBuilt 1979 · S/N 31-7912085 N227TMMed Care Inc · Grand Island, NES/N 31T-7400008 N2287P250 Flyers LLC · Middletown, DEBuilt 1957 · S/N 23-898 N2288PChisum Robert · Lorenzo, TXS/N 23-899 N2291PNice Flight LLC · Medford, ORBuilt 1957 · S/N 23-902 N2293PGaston Stephen · Saint James City, FLBuilt 1957 · S/N 23-905 N2296PTarrant County College · Fort Worth, TXBuilt 1957 · S/N 23-908 N2299PMoeller Wendell L · Porter, TXBuilt 1957 · S/N 23-884 N229MKyzer Aviation Holdings LLC · Fort Mill, SCBuilt 1969 · S/N 27-4252 N22AWAir What What LLC · Clackamas, ORBuilt 1979 · S/N 31T-7920059 N22VTMcmath Robert Roy · Seeley Lake, MTBuilt 1977 · S/N 27-7754074 N22WFBemidji Aviation Services Inc · Bemidji, MNBuilt 1978 · S/N 31T-7920007 N22ZZTreicher Peter · East Aurora, NYBuilt 1979 · S/N 27-7954043 N230ASN230as LLC · Wilmington, DEBuilt 1980 · S/N 31-8012062

Back to AD 2009-13-06 R1