Registered aircraft · 68,377

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.

N381FCBrown Shane · Ozark, MOBuilt 1976 · S/N 28-7615197 N381GAtp Taa LLC · Wilmington, DEBuilt 2020 · S/N 2881429 N381JUS Aviation Group LLC · Denton, TXBuilt 1980 · S/N 17274183 N381LJBlue Rudder Aviatoin LLC · Excelsior, MNBuilt 2002 · S/N 2843540 N381MAKnight Wings LLC · Matthews, NCBuilt 2005 · S/N 1397-2005 N381MBStrobridge Mark D · Bunnell, FLBuilt 1981 · S/N 17275303 N381MGMissionary Air Group Inc · Burlington, NCBuilt 1975 · S/N 17265873 N381NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2023 · S/N 2881666 N381WGGoodman Bob · Opelika, ALBuilt 2003 · S/N 81657 N3820RAnagnos Nick C · East Moline, ILS/N 28-5836 N3820T3820t Aviation LLC · Fort Smith, ARBuilt 1967 · S/N 28R-30137 N3820ZBudd Kirkland G · Rushville, NES/N 18-7560 N38211Watford Aeroservice LLC · Watford City, NDBuilt 1977 · S/N 28-7716232 N38214Mora Steven T · Corning, CABuilt 1977 · S/N 28-7790530 N3821FKennedy Karen E · Gulf Breeze, FLBuilt 1977 · S/N 0789 N3821KSoar Above Flight Solutions LLC · Englewood, TNBuilt 1967 · S/N 28-23739 N3821PRadach Kenneth D · Copper Center, AKBuilt 1955 · S/N 22-3511 N3821TDoty David W · Lakeland, FLBuilt 1968 · S/N 28R-30959 N38223Kuhn Brent · Bloomer, WIS/N 6869 N3822FBelser Mark · Avon, OHBuilt 1977 · S/N 0790 N3822QMatanane Roke C · Barrigada, GUBuilt 1971 · S/N 17259922 N3822TVanderblom David Y · Oxford, ALBuilt 1967 · S/N 28R-30139 N3823FGovednik Francis J · Flower Mound, TXBuilt 1977 · S/N 0791 N3823ZFranks Cory B · Idalou, TXBuilt 1960 · S/N 18-7563 N38245Foster Gifford L · Torrington, WYBuilt 1941 · S/N 5916 N38248Plane Training LLC · Rapid City, SDBuilt 1977 · S/N 28-7716234 N3824MDraveling Larry J · Wasilla, AKFirst renewal noticeBuilt 1947 · S/N 12-2744 N3824RAbove All Aviation Inc · Santa Barbara, CABuilt 1980 · S/N MC-741 N3824TStevens Zane Kelly · Carthage, TNBuilt 1967 · S/N 28R-30141 N3824ZMoore Ricky J · Milton, KYBuilt 1980 · S/N MC-644 N38250Elkins John H · Lancaster, MABuilt 1977 · S/N 28-7790531 N38251Bazil Nick G · Lehighton, PAS/N 5-923 N38254Syracuse Flying Club Inc · Fayetteville, NYBuilt 1977 · S/N 28-7790534 N38256Ringler Neil H · Baldwinsville, NYBuilt 1977 · S/N 28R-7737085 N3825QFischer Roger G · Torrance, CABuilt 1971 · S/N 17259925 N3825TArmstrong Aviation Services LLC · Freeport, PABuilt 1967 · S/N 28R-30143 N38262Hansen Daniel A · Kotzebue, AKBuilt 1941 · S/N 6887 N38265Recipe System US Inc · Torrance, CABuilt 1977 · S/N 28-7716236 N38267Andy Mack Management LLC · Wilmington, DEBuilt 1977 · S/N 28-7716237 N3826MBaugh Caleb · Carthage, MOBuilt 1947 · S/N 12-2568 N3826PBauries Brian W · Abilene, TXBuilt 1955 · S/N 22-3516 N3826ZWebster William S · Eden, WYBuilt 1961 · S/N 18-7569 N38270Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1941 · S/N 6896 N38273Southern Aircraft Consultancy Inc Trustee · Casper, WYS/N 28R-7737086 N3827MFox James Douglas · Pittsburg, ILBuilt 1978 · S/N 28-7890335 N3827TBrauer Noah J · Covington, KYBuilt 1967 · S/N 28R-30145 N3828PPupator Peter Trienko · Willow, AKBuilt 1955 · S/N 22-3518 N3828ZOrvin Sanden Inc · Wyndmere, NDBuilt 1960 · S/N 18-7571 N38291Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1977 · S/N 28-7716240 N38293L & A Bennett Second Family L P · Renton, WAS/N 28-7790537

Back to AD 90-04-06 R1