Registered aircraft · 68,375

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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.

N280BGD&J Aviation LLC · Gotha, FLBuilt 2002 · S/N 2842167 N280BRRegistration Pending · Denver, CORegistration pendingBuilt 2006 · S/N 2124 N280CABlue Skies Flight Club LLC · Cameron Park, CABuilt 2002 · S/N 24826 N280DABouffard Marcel · Flowery Branch, GABuilt 1977 · S/N 28R-7737154 N280DCCopp David G · Westminster, COBuilt 2009 · S/N 2358 N280EHEnstrom Helicopter Corp · Menominee, MIBuilt 2026 · S/N 2179 N280ERNew Course Aviation Co · Golden, COBuilt 2005 · S/N 2110 N280FSAirflight LLC · Wilmington, DEFirst renewal noticeBuilt 2003 · S/N 2094 N280HGGeorgia Aviation Authority · Eastman, GABuilt 2013 · S/N 2843733 N280JAFlying Tigers Flight School Ltd · Houston, TXBuilt 2000 · S/N 172S8620 N280JGEdwards Jonathan S · Marysvale, UTBuilt 1968 · S/N 17700498 N280JSStefanini Joseph M · Akron, OHS/N 1510 N280LASeipp Stephen C · Laurel, DEBuilt 1999 · S/N 2085 N280MMrr Spraying LLC · Shelby, MTFirst renewal noticeS/N 749 N280MAMcgarity Daniel Scott · Essex, MOBuilt 2004 · S/N 4552004 N280MGM&M Charter LLC · Mountville, PABuilt 1978 · S/N 1135 N280MHGulf Coast Helicopters Inc · Pearland, TXBuilt 1988 · S/N 2022 N280MLLundy Michael · Stephenville, TXS/N 2032 N280MSM & S Air Service Inc · Honeoye Falls, NYBuilt 1973 · S/N 17261450 N280NARohner Harlan G · Willmar, MNS/N 2058 N280PTAzure Leasing LLC · Oakdale, PABuilt 1989 · S/N 2841230 N280QCasey Aviation Inc · Burke, TXBuilt 1975 · S/N 1011 N280SASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1990 · S/N 11070C N280SEKennicott Wilderness Air LLC · Boonton, NJBuilt 1954 · S/N 18-3803 N280SHRottor Aviation LLC · Jasper, INBuilt 2003 · S/N 2095 N280SMAirpark Aviation LLC · Manchester, NHBuilt 1999 · S/N 2083 N280TKrengel Lawrence E · Marengo, ILBuilt 1953 · S/N 18-2394 N280TCNobles Gary D · Fairview, TXS/N 28-21227 N280WRBeacon Aviation Flight Services LLC · Rogers, ARBuilt 1977 · S/N 1108 N280YSCrabtree Martin L · Sedalia, MOS/N BING-1 N2810MDavis Ronald L Jr · Soldotna, AKBuilt 1946 · S/N 12-1263 N2810QMcdowell Kevin J · Williamsburg, VABuilt 1971 · S/N 17259810 N2810TBoudreau Robert D · Rusk, TXBuilt 1972 · S/N 28R-7235137 N28117Olson Alan A · Garnet Valley, PABuilt 2011 · S/N 80188 N28118Nightingale Patrick R · Lakewood, CABuilt 1940 · S/N 4594 N2811GNablo Dustin · Haddam Neck, CTBuilt 1967 · S/N 170 N2811MSale Reported · Rio Grande City, TXSale reportedBuilt 1977 · S/N 28R-7837101 N2811RLantz Raymond J · Huntington Beach, CABuilt 1969 · S/N 28R-35296 N2811WRegistered aircraftAssigned, pending cancellationS/N TD-66 N2811ZHill Daniel A · Soldotna, AKBuilt 1959 · S/N 22-6804 N2812QHammond David J · Chesterfield, VABuilt 1971 · S/N 17259812 N2812XHarris Rodger C · Titusville, FLBuilt 1967 · S/N 17700212 N2812ZRubbert Randy C · Reynolds, NDS/N 22-6805 N2813Piper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010052 N28132Hesse Roy A · Stacy, MNS/N 4606 N2813DMcbride Kenneth B · San Martin, CAFirst renewal noticeBuilt 1956 · S/N 29 N2813QOriginal Design Ministries · Eatonville, WABuilt 1971 · S/N 17259813 N2813TKamper Gregory S · Ripon, CABuilt 1972 · S/N 28-7225237 N28143Powell Kenneth W · Ann Arbor, MIBuilt 1940 · S/N 5-116 N28144Maloy Toby · Albuquerque, NMS/N 5-117

Back to AD 90-04-06 R1