Skip to content

Registered aircraft · 3,961

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-21-02-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:87-21-02-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:87-21-02-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:87-21-02-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:87-21-02-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:87-21-02-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.

N615SALordemann Holdings LLC · Kalispell, MTBuilt 1978 · S/N 340A0427 N6161XGolden Eagle Aircraft LLC · Boulder, COS/N 421C0895 N6161ZSkybound Holdings LLC · Orlando, FLBuilt 1978 · S/N 414A0019 N616DFugate Kirk A · El Dorado Springs, MOS/N 421B0140 N616RMMnemonics Inc · Melbourne, FLBuilt 1973 · S/N 414-0375 N616STK&S Flights LLC · Sweet Valley, PABuilt 1981 · S/N 414A0806 N6176XCentral Texas College · Killeen, TXFirst renewal noticeBuilt 1978 · S/N 310R1315 N6177XMayhew William D · Round Lake, ILBuilt 1978 · S/N 310R1316 N617CCRiley Livestock Inc · Mayfield, KYS/N 421C0897 N6180CBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 1978 · S/N 310R1318 N6181C6181c LLC · Saginaw, MIBuilt 1978 · S/N 310R1320 N6184QMarc Inc · Bolton, MSBuilt 1968 · S/N 320F-0034 N6186XSaint Louis Cessna Group LLC · Saint Louis, MOBuilt 1978 · S/N 310R1325 N618CAHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0620 N618MROshaughnessy Stephen M · Littleton, COBuilt 1979 · S/N 340A0653 N6192XSongbird Group LLC · Andover, MNBuilt 1978 · S/N 310R1329 N6193QRedstar Air Shows Inc · Discovery Bay, CAFirst renewal noticeBuilt 1968 · S/N 320F-0043 N6195QSunny Aviation LLC · Kalispell, MTBuilt 1968 · S/N 320F-0045 N6195XSlc Service Leasing Company LLC · Tipton, IABuilt 1978 · S/N 310R1331 N619ACFeed Yard Industrial Solutions LLC · Amarillo, TXBuilt 1977 · S/N 421C0336 N61AJCoco Air Ltd Trustee · Wilmington, DEBuilt 1978 · S/N 421C0457 N61DDKissner Mark E · Frederick, MDS/N 340A1037 N61JV61jv LLC · Chuckey, TNS/N 421C0097 N61RWAerial Services Inc · Cedar Falls, IABuilt 1966 · S/N 320E0001 N61WWKingsboro David · Menifee, CABuilt 1973 · S/N 340-0203 N6209XMiller Aviation LLC DBA · Huntington, INBuilt 1978 · S/N 310R1339 N620CAFar West Leaseco LLC · Kalispell, MTS/N 414-0916 N620JPPreiss Aviation Inc · Poplar Grove, ILBuilt 1972 · S/N 310Q0639 N6219CAbbott Todd Christopher · Houston, TXBuilt 1977 · S/N 340A0424 N621SPKokkas Athanasios · Ocala, FLBuilt 1974 · S/N 310R0075 N6221CSahuaro Enterprises Inc · Moreno Valley, CAS/N 340A0426 N6225XN6225x LLC · Henderson, TNBuilt 1979 · S/N 340A0688 N6228XMad Doog Aviation LLC · Kalispell, MTBuilt 1977 · S/N 340A0431 N622LPClear Skies Avionics Inc · Clearwater, FLS/N 310L-0131 N622QTSol Aerial Surveys LLC · Las Vegas, NVS/N 310R0828 N622TRL C A Inc · Alamo, CABuilt 1980 · S/N 421C0858 N6240XCoal Black Cattle Co LLC · Roundup, MTBuilt 1977 · S/N 340A0437 N6249QKnudsen Russell G · East Troy, WIBuilt 1969 · S/N 401A0049 N624CAClarke Cecil Jr Trustee · Katy, TXBuilt 1975 · S/N 402B0876 N624PKBas Part Sales LLC · Greeley, COBuilt 1971 · S/N 421B0144 N6255QValiair Limited Company Trustee · Casper, WYBuilt 1969 · S/N 401A0055 N6258NTango Victor Aviation LLC · Kingsburg, CABuilt 1978 · S/N 340A0449 N625JLTurbulent Returns LLC · Minneapolis, MNBuilt 1980 · S/N 414A0508 N6268QChuss Edward J · Metamora, MIS/N 310Q0526 N6269NJuliet Tango Capital LLC · Saginaw, MIBuilt 1978 · S/N 340A0454 N626DRK And L Transportation LLC · Carterville, ILFirst renewal noticeS/N 421C0512 N626HMRb Aviation LLC · Tyler, TXBuilt 1981 · S/N 340A1280 N6272TBernaiche Travis · Caribou, MEBuilt 1969 · S/N 421A0141 N6276XWj Bolton Farms LLC · Mark Tree, ARBuilt 1978 · S/N 340A0460 N6277QFly Me LLC · Sparta, TNBuilt 1973 · S/N 310Q0747

Back to AD 87-21-02 R1