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.

N3776TFractional Villas Inc · Del Mar, CABuilt 2004 · S/N T18208314 N377CValiair Limited Company Trustee · Casper, WYBuilt 2005 · S/N 2222 N377DWSoutheastern Aircraft Inc · Birmingham, ALBuilt 1965 · S/N 27-3063 N377HAGrasse Louis Phillip Trustee · Saint Louis, MOBuilt 2004 · S/N T20608499 N377HCHigh Altitude Aviation LLC · High Point, NCBuilt 2002 · S/N 4636332 N377JRTrinity Aviation LLC · Oklahoma City, OKBuilt 1969 · S/N 32-11 N377MEBrandywine Enterprises Lp · Beverly Hills, CABuilt 2000 · S/N T20608226 N377RTElevated Aviation LLC · Silt, COS/N 3257377 N377SMJrt Flying Co · Roanoke, VABuilt 1977 · S/N 32R-7780223 N377USEaton Brian · Tampa, FLBuilt 2005 · S/N 27-0337 N3785ERegistration Pending · Sabin, MNRegistration pendingS/N 36-7860077 N378HPBelair Venice Aviation LLC · Osprey, FLBuilt 2004 · S/N 3257347 N378MECamelot Aviation LLC · Phoenix, AZBuilt 2000 · S/N T20608228 N378MMBento De Deus Amarildo · Margate, FLBuilt 1978 · S/N 31-7812118 N378MSJulius Kaleb · Tucson, AZBuilt 2002 · S/N T18208082 N379BFDay Darrell Rodney · Sahuarita, AZBuilt 2004 · S/N T18208253 N379GPGreat Pacific Aviation Services Inc · Grants Pass, ORBuilt 2005 · S/N T18208379 N379HPLiquid Transport Inc · Camilla, GABuilt 2004 · S/N 3257353 N37CKSale Reported · Saint Thomas, VISale reported, pending cancellationBuilt 1962 · S/N 500A-1251-76 N37GCKoumi Enterprises LLC · Houston, TXBuilt 2002 · S/N 3257273 N37REGiroux Aeronautical Company LLC · Fulton, NYBuilt 1976 · S/N 32R-7780114 N37RTPlane Fun Inc Tr Trustee · Snellville, GABuilt 1997 · S/N 4636082 N3800WJdj Transport LLC · Wilmington, DEBuilt 1966 · S/N 32-40128 N380CASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1999 · S/N 3257080 N38127Trager Limestone LLC · Chillicothe, MOS/N 32R-7780387 N381CBGrubbs Steven O · Bellaire, TXBuilt 1981 · S/N 32R-8129068 N381HPHopkins George · West Covina, CABuilt 2005 · S/N 3257374 N381KHPhoenix Fire Protection LLC · Nampa, IDBuilt 2005 · S/N 27-0345 N38205Albright John A · Richmond, INBuilt 1977 · S/N 32R-7780403 N382HP382 Hp LLC · Pt Pleasant Beach, NJBuilt 2006 · S/N 3257411 N382JMGullicksrud Mark Robbe · Strum, WIBuilt 1981 · S/N 32R8229026 N38331Johnston Craig J · Ocean City, NJBuilt 1977 · S/N 32-7740082 N38334Gsm Air LLC · Old Tappan, NJBuilt 1977 · S/N 32R-7780415 N3838EPiper Aircraft Inc · Vero Beach, FLBuilt 1978 · S/N 36-7960068 N3839EPiper Aircraft Inc · Vero Beach, FLBuilt 1978 · S/N 36-7960069 N383CSven 1 LLC · Center Moriches, NYBuilt 2001 · S/N 3257258 N38597Bad Dog Aviation Inc · Meridianville, ALBuilt 1977 · S/N 32R-7780445 N385TCLiebl Holdings LLC · Claremore, OKS/N T18208385 N385WKTriva Solutions LLC · El Paso, TXS/N 27-4130 N38617Bros Flying Low LLC · Kalispell, MTS/N 32R-7780447 N38725Maynard Geoffrey · New Marlborough, MABuilt 1977 · S/N 32R-7780465 N38746Campbell David A Trustee · Bolivar, MOBuilt 1977 · S/N 32R-7780466 N387TCBass Joel W · Okeechobee, FLBuilt 2005 · S/N T18208386 N38854Schmidt Ryan A · Medinah, ILFirst renewal noticeBuilt 1977 · S/N 32-7740098 N388JGBeggins Thomas J · Madison, CTBuilt 2000 · S/N 2021 N388TWeimer David J · Knightstown, INBuilt 1973 · S/N 32-7440044 N3891FJjcw Aviation Inc · Athens, TXBuilt 1976 · S/N 32R-7680407 N38997Blg Air Inc · State College, PABuilt 1977 · S/N 32R-7780496 N38KCChanney Aviation Group LLC · Las Vegas, NVBuilt 1983 · S/N 31-8352033 N38TCInternational Albatros Holdings Corp · Cottonwood, AZBuilt 1967 · S/N 31-96

Back to AD 91-21-01 R1