Registered aircraft · 11,798

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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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.

N6599GPremiere Aviation Inc · Concord, CAS/N 421C0275 N659FEFederal Express Corp · Memphis, TNBuilt 1995 · S/N 757 N659RJFoerstel Edward · Miami Beach, FLBuilt 1984 · S/N 421C1408 N659WGBuds Tn LLC · Lexington, KYBuilt 2018 · S/N 525-1002 N65BEStarwood Air LLC · Missoula, MTBuilt 1994 · S/N E-2837 N65CATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 560-0455 N65DLChestnut Northern Partners LLC · Farmington Hills, MIBuilt 1993 · S/N 258224 N65JEVan Wadle Aviation LLC · Blairsville, GABuilt 1978 · S/N E-1231 N65LMAero Compression LLC · Macon, GABuilt 1999 · S/N TH-1902 N65MGRegistered aircraftN-number assigned (import), not yet registeredS/N LA-79 N65MH993 LLC · Davidson, NCS/N TH-2050 N65MSSummey Aviation LLC · Asheville, NCS/N LW-202 N65MTM&M Transit LLC · Winter Park, FLS/N LA-38 N65RASky Cloud Ventures LLC · Seagrove Beach, FLS/N RJ-9 N65RLLevi Ray & Shoup Inc · Springfield, ILBuilt 1992 · S/N 560-0179 N65RTProfessional Travel Inc · La Porte, INBuilt 1975 · S/N BB-97 N65TADodson International Parts Inc · Rantoul, KSBuilt 1971 · S/N LJ-538 N65TCCloud 8 LLC · West Hartford, CTBuilt 1987 · S/N E-2385 N65TWRound Hound Holdings LLC · Lewes, DES/N BB-902 N65WWSanders Aviation Inc · Jasper, ALBuilt 1981 · S/N 501-0194 N66Federal Aviation Administration · Oklahoma City, OKBuilt 1987 · S/N FF-1 N6600LBonanza Partners LLC · Newton Centre, MABuilt 1977 · S/N E-1074 N6604LShoals Aircraft Leasing And Operations LLC · Florence, ALS/N BB-1121 N660CKPrecision Delta Corp · Ruleville, MSBuilt 1979 · S/N TH-1079 N660FEFederal Express Corp · Memphis, TNBuilt 1995 · S/N 759 N660FKAviation Management Sales LLC · Fort Pierce, FLS/N 386 N660FLDandy Thomas · Tehachapi, CAS/N FL-660 N660FMAviation Management Sales LLC · Fort Pierce, FLS/N 484 N660FNAviation Management Sales LLC · Fort Pierce, FLS/N 443 N660FYAviation Management Sales LLC · Fort Pierce, FLS/N 383 N660MWMarvin Lumber And Cedar Co · Warroad, MNBuilt 1996 · S/N UE-215 N660PAFriendly Aviation LLC · Dallas, TXBuilt 1993 · S/N 650-0230 N6613AAustin Bill DBA · Sparta, TNBuilt 1983 · S/N E-2070 N6617NSeal William T · Eagle, IDBuilt 1983 · S/N TH-1373 N661BPBlack Potato Express LLC · Bakersfield, CABuilt 2014 · S/N 525-0832 N661FEFederal Express Corp · Memphis, TNBuilt 1995 · S/N 760 N661KEBio-Wings LLC · Blue Mountain, MSBuilt 2005 · S/N E-3618 N661USDelta Air Lines Inc · Atlanta, GABuilt 1989 · S/N 23719 N661WAKapowsin Air Sports Ltd · Shelton, WABuilt 1998 · S/N 208B0661 N661WLButterbar Leasing LLC · Virginia Beach, VABuilt 1984 · S/N TH-1404 N662AVBerry Aviation Inc · San Marcos, TXBuilt 1980 · S/N 662 N662FEFederal Express Corp · Memphis, TNBuilt 1996 · S/N 761 N662JSHughes Leasing Co · Miami, FLBuilt 1976 · S/N LW-176 N662LMFreedom LLC · Pass Christian, MSBuilt 2002 · S/N 208B0978 N6633TC C I C Aircraft Division One LLC · Kalispell, MTBuilt 1977 · S/N 421C-0277 N6639KXp Skyhawk LLC · San Luis, AZBuilt 1979 · S/N TH-1049 N663ATAirtrex Registration Corp Trustee · Wichita, KSS/N FL-663 N663FEFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 766 N663JMCh Aviation LLC · Wilmington, DES/N TH-2121 N6640UDc Air Corp · Aventura, FLBuilt 1979 · S/N E-1537

Back to AD 2006-16-18 R1