Registered aircraft · 5,086

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:91-21-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:91-21-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:91-21-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:91-21-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:91-21-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:91-21-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.

N6416YMcm Aviation LLC · Estero, FLBuilt 1967 · S/N 27-3708 N6418YWalker Gilbert R · Brentwood, TNBuilt 1967 · S/N 27-3710 N642JF6 Xt LLC · Fort Lauderdale, FLBuilt 2005 · S/N 3255040 N642WAGunnslinger Air LLC · Destin, FLBuilt 1979 · S/N 31-7952084 N6430YFord William E · Minnetonka, MNBuilt 1967 · S/N 27-3728 N644BCRegistration Pending · Sioux Falls, SDRegistration pendingBuilt 1976 · S/N 32R-7680229 N645BCNolan Kevin J · North Bend, ORBuilt 1974 · S/N 32-7540056 N6460YRogers Anthony J · Boynton Beach, FLBuilt 1967 · S/N 27-3754 N6463UVip Leasing LLC · Mesa, AZBuilt 2004 · S/N T20608477 N6472YNorman Robert Alan · Zanesville, OHBuilt 1967 · S/N 27-3767 N6475LTerra Flight Aerial Imaging Inc · Spring, TXBuilt 1969 · S/N 31-436 N647CPUnicorn Aviation Inc · Canton, CTBuilt 2005 · S/N 27-0332 N6480YTechnical Education Services Inc · Virginia Beach, VABuilt 1967 · S/N 27-3776 N6485YMeluskey Michael · Christiansted, VIBuilt 1967 · S/N 27-3782 N648TStefaniak Paul B · Richmond, TXBuilt 1995 · S/N 4636002 N64APD&N Holdingsinc · Boca Raton, FLBuilt 1974 · S/N 31-7405178 N64BMCoker Janie K · Tyler, TXBuilt 1990 · S/N 27-0073 N64RFLake Seawolf LLC · King Of Prussia, PABuilt 1991 · S/N 126 N64TWPlane Fun LLC · Garretson, SDS/N 4636054 N64USJc Investors Group LLC · Coral Springs, FLBuilt 1974 · S/N 32-7440122 N64WMSeg Leasing LLC · Selinsgrove, PAS/N 61P-0360-112 N6501PGarcia Perez Alberto Carlos · Houston, TXBuilt 1964 · S/N 27-2489 N6503YShe-Rat Aviation Inc · Wilmington, DEBuilt 1967 · S/N 27-3791 N6507FToledo Thiago Amaral · Bonita Springs, FLBuilt 1976 · S/N 32R-7780028 N650MATerra Flight Aerial Imaging Inc · Spring, TXBuilt 1999 · S/N T20608120 N650PA-Z Leasing LLC · Kenosha, WIBuilt 1965 · S/N 27-2793 N6518YKiley Clement · Plainville, MAS/N 27-3808 N651RMackey Aviation LLC · Talking Rock, GABuilt 1960 · S/N 39261 N65234Moore Tommy Vance · Monahans, TXBuilt 2004 · S/N T18208301 N6527YAll Pro Electrical Contractors Inc · Silsbee, TXBuilt 1967 · S/N 27-3800 N65280Jacobson David A Trustee · Bend, ORBuilt 2004 · S/N T20608467 N652PLN652pl LLC · Saint Joseph, MOBuilt 1980 · S/N 31-8052159 N65309Satoyama Molokai LLC · Kaunakaka Molokia, HIBuilt 2004 · S/N T20608482 N6531YSmith Henry C III · Essexville, MIBuilt 1967 · S/N 27-3824 N65324Bickerstaff Mike · Port Orange, FLBuilt 2004 · S/N 18281421 N65348Anselmetti Federico · South Miami, FLBuilt 2004 · S/N T18208311 N6537AYellow Jacket Aero LLC · Plymouth, MNBuilt 1978 · S/N 27-7954002 N653WWBerry Aviation Inc · San Marcos, TXBuilt 2005 · S/N T20608521 N65431Caliber Capital Holdings LLC · Homosassa, FLBuilt 2004 · S/N T18208302 N65445International Air Services Inc Trustee · Carson City, NVBuilt 2004 · S/N T18208322 N65452Jf Aviation LLC · Minot, NDBuilt 2004 · S/N T20608491 N65459Vitatoe Industries Inc · Chillicothe, OHBuilt 2004 · S/N T20608492 N65474Tk Leasing Lc · Fruit Heights, UTFirst renewal noticeBuilt 2004 · S/N T20608493 N6549AGregory P Cook LLC · Spokane, WABuilt 1978 · S/N 27-7954006 N654MDProfessional Storage Inc · Hobe Sound, FLBuilt 1976 · S/N 27-7754018 N654ZZarmada LLC · Issaquah, WABuilt 2006 · S/N T18208627 N65515Peterson Darren · Janesville, WIBuilt 2004 · S/N T18208325 N6556VGiannola Peter S · San Diego, CAS/N 32-15 N6561ARandolph Fielding A M · Jackson, TNBuilt 1978 · S/N 27-7954008 N6561YN6561y LLC · Auburn, ALBuilt 1968 · S/N 27-3858

Back to AD 91-21-01 R1