Skip to content

Registered aircraft · 1,889

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:95-19-15-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:95-19-15-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:95-19-15-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:95-19-15-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:95-19-15-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:95-19-15-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.

N6078LHott Jack R · Springboro, OHBuilt 1972 · S/N AA5-0178 N6080LBowers Scott · Soddy Daisy, TNBuilt 1972 · S/N AA5-0180 N6083LSorensen Paul E Jr · Los Lunas, NMBuilt 1972 · S/N AA5-0183 N6085LLevy Stanley · Arcadia, CABuilt 1972 · S/N AA5-0185 N6087LSundsmo Sheldon L · Adams, WIBuilt 1972 · S/N AA5-0187 N6088LCollins Harold H · North Las Vegas, NVBuilt 1972 · S/N AA5-0188 N6090LDarcor Inc · Hampstead, NCBuilt 1972 · S/N AA5-0190 N6091LMartino John F · Kingston, NYBuilt 1972 · S/N AA5-0191 N6096LC&C Airlines LLC · Mesa, AZBuilt 1972 · S/N AA5-0256 N6097LPetrovich Michael · Simpsonville, SCBuilt 1972 · S/N AA5-0257 N6155JAnderdoc Aviation Inc · Wilmington, DEBuilt 1974 · S/N AA50503 N616BYLearjetjohn Flying Club LLC · Tanner, ALS/N AA5A0890 N6180LAryvue Inc · Cordele, GABuilt 1972 · S/N AA5-0280 N618ARoberts Jeffrey M · Markleville, INBuilt 1975 · S/N AA5A-0006 N62072Lytwyn Marcian · West Chesterfield, NHBuilt 1977 · S/N AA5A-0350 N620FTSwiderski Jacek · Angwin, CABuilt 1990 · S/N 10009 N622FTReese William A · New Smyrna Beach, FLBuilt 1991 · S/N 10022 N623SCTiger Pilots Inc · Iowa City, IABuilt 1979 · S/N AA5B1199 N625CTRegistered aircraftBuilt 1991 · S/N 10032 N626FT626ft LLC · Los Angeles, CABuilt 1991 · S/N 10035 N6299UKeelin Freddie B · Sagle, IDBuilt 1975 · S/N AA5-0782 N62CLConklin Christopher S · Oshkosh, WIBuilt 1977 · S/N AA5B0470 N62ERMantiply Paul · Columbia, CABuilt 1979 · S/N AA5B1257 N630FTAilabouni Adam · Northfield, MNBuilt 1991 · S/N 10042 N633FTPlanesworld LLC · Jasper, GABuilt 1991 · S/N 10047 N634FTNew Life Aviation LLC · Greeneville, TNBuilt 1991 · S/N 10048 N6366LFritel Construction Co Inc · Stanley, NDS/N AA5-0246 N6367LM&S Aero LLC · Wilmington, DEBuilt 1972 · S/N AA5-0237 N6373LMcdermott Scott A · Boston, MABuilt 1972 · S/N AA5-0243 N6382LBagby Michael · Vero Beach, FLS/N AA5-0242 N639GSKatzen Edmund · Westhampton, NYBuilt 1991 · S/N 10041 N6425LRegistration Pending · Hudsonville, MIRegistration pendingBuilt 1972 · S/N AA5-0227 N6464ZFlying Tiger LLC · Birmingham, ALBuilt 1979 · S/N AA5B1221 N6500ERegistered aircraftBuilt 2005 · S/N 10246 N6506AFallon Timothy R · Ithaca, NYBuilt 2005 · S/N 10247 N6510LPurpose Flight Inc · Wilmington, DES/N AA5-0610 N6513ZDalcair Inc · Fort Washington, PAS/N 10249 N6521LRegistered aircraftBuilt 1974 · S/N AA5-0685 N6533LNorthcutt Cecil W III · Ponder, TXBuilt 1974 · S/N AA5-0633 N6551LParker Kerry · Hobbs, NMBuilt 1974 · S/N AA5-0651 N6554BCitizen Aero Inc Trustee · Sheridan, WYBuilt 2006 · S/N 10251 N663SMMacmoyle Scott · Blairstown, NJBuilt 1976 · S/N AA5B0370 N666GAInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N AA5B1136 N669KPClink Andrew D · Phoenix, AZBuilt 1978 · S/N AA5A0701 N66RDTiger Air 2 LLC · Atlanta, GAFirst renewal noticeBuilt 1978 · S/N AA5B1013 N67296Duwayne Michael · Hendersonville, TNBuilt 1975 · S/N AA5-0764 N6768FFallis Robert P · Keller, TXBuilt 1972 · S/N AA5-0182 N676WLeymaster Michael J · Westerville, OHBuilt 1977 · S/N AA5B0676 N6787TStar Aerobatics LLC · Columbia City, INBuilt 1976 · S/N AA5A0212 N67GTTiger Partners M/A LLC · Wilmington, DEBuilt 1977 · S/N AA5B0414

Back to AD 95-19-15 R1