Skip to content

Registered aircraft · 20,484

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:84-10-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:84-10-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:84-10-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:84-10-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:84-10-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:84-10-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.

N195STFly4sport LLC · Kasilof, AKBuilt 1950 · S/N 7527 N195TGGoodwin Pilar Z · Lancaster, CABuilt 1949 · S/N 7341 N195TWHenkemeyer Joseph · Cave Creek, AZBuilt 1952 · S/N 7981 N195UDowd Darin R · Frisco, TXBuilt 1951 · S/N 7705 N195VOdom John C · Fredericksburg, TXBuilt 1950 · S/N 7471 N195VFMcfarlane Claude L III · Fitchburg, WIBuilt 1948 · S/N 7268 N195VHKoehn Shane · Scooba, MSBuilt 1949 · S/N 7549 N195WGFisher Group LLC · Ashland City, TNBuilt 1952 · S/N 7926 N195WHCarolina Aero Tech LLC · Hilton Head Island, SCS/N 7324 N195WLRegistration Pending · Coldwater, MIRegistration pendingS/N 7620 N195WSSaloga William A Trustee · Batavia, ILBuilt 1952 · S/N 7908 N195WTRowe James D · Nome, AKBuilt 1954 · S/N 16128 N195XBusinessliner 190 Express LLC · Rogers, MNFirst renewal noticeBuilt 1949 · S/N 7464 N195YYoung Kenneth D · La Verne, CABuilt 1951 · S/N 7629 N1960CSenger Bruce D · Mount Solon, VABuilt 1952 · S/N 7919 N1960MJereb Robert M · Rohnert Park, CABuilt 1976 · S/N 18264505 N1960XPena Fermina · Brentwood, NYBuilt 1964 · S/N 18256060 N1961DMulligan Kevin S · Port Alexander, AKBuilt 1961 · S/N 1850286 N1961MSwindle Malorie J · Birmingham, ALBuilt 1976 · S/N 18264506 N1961UMccarthy Trevor William · Addison, TXBuilt 1974 · S/N U20602312 N1967XInternational Air Services Inc Trustee · Carson City, NVBuilt 1965 · S/N 18256067 N1968RCloud Transport Operations LLC · Albuquerque, NMS/N 21064375 N19694Farrell Timothy S · New Meadows, IDBuilt 1981 · S/N 18053179 N1969XCrouch Jeffrey L · Rockingham, NCBuilt 1965 · S/N 18256069 N196ABrennemann Brian L · Hyannis, NES/N 18051868 N196AVWarren Mark W · Arlington, WABuilt 1958 · S/N 51326 N196PWC I Mckown & Son Inc · Newton, WVBuilt 2004 · S/N 18281368 N196SA3d Capture LLC · Beaumont, TXBuilt 2003 · S/N 20608197 N1970XJohnson Christopher S · Portland, ORBuilt 1965 · S/N 18256070 N1971XHigh Country Air Service LLC · Albuquerque, NMBuilt 1965 · S/N 18256071 N1973JMormile Jason B · Fultonville, NYBuilt 1973 · S/N 18262469 N1973USilver Fox Aviation LLC · Bay City, MIBuilt 1974 · S/N U20602316 N1973XSuttle Joseph Scott · Moody, ALBuilt 1965 · S/N 18256073 N1975XFirefly Aviation LLC · Apison, TNBuilt 1965 · S/N 18256075 N1976MJackling Eric S · Rochester, NYS/N 182-64331 N1976XGmss LLC · San Diego, CABuilt 1965 · S/N 18256076 N1978TSilva Daniel · Mapleton, ILBuilt 1974 · S/N 18263132 N197BZGlide Away LLC · Wilburton, OKBuilt 1979 · S/N 18267326 N197FTuin Brian A · Fort Worth, TXBuilt 1980 · S/N 18267671 N197VMclaine James D · Clarion, PABuilt 1964 · S/N 18051416 N1981MOlson Robert Carter · Gold Canyon, AZBuilt 1976 · S/N 18264510 N1981XB2 Aviation LLC · Sisters, ORBuilt 1965 · S/N 18256081 N1982RLaughlin Michael · Anchorage, AKBuilt 1975 · S/N U20602913 N1982XWheeler Joseph T · Chandler, AZS/N 18256082 N1983CRivera Carlos A · Morriston, FLBuilt 1955 · S/N 31572 N1984X140kts LLC · Quilcene, WABuilt 1965 · S/N 18256084 N1985MSokalsky Leigh Anne · Monee, ILBuilt 1976 · S/N 18264514 N1988MFacility Concepts LLC · Jackson, MSBuilt 1976 · S/N 18264517 N1988XN1988x LLC · Erie, COBuilt 1965 · S/N 18256088 N1989MCrosswind Aviation LLC · Friendswood, TXBuilt 1976 · S/N 18264518

Back to AD 84-10-01 R1