Registered aircraft · 68,369

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.

N2503VAlpha Aviation Holdings Group LLC · Raleigh, NCBuilt 1982 · S/N 38-82A0069 N2503ZAviation Financial Corp · Torrance, CABuilt 1977 · S/N 613-77 N25047Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15280514 N2504MAerial Messages Leasing Co · Longwood, FLBuilt 1946 · S/N 12-1002 N2504WBade Russell E · Carlsbad, CAS/N 22839 N25053Southwinds Export Inc · Kissimmee, FLNon-citizen corporation, flight hours not reportedS/N 15280517 N25057Nino Jose · Kenilworth, NJBuilt 1977 · S/N 15280520 N25059West William Douglas · Newton, NCS/N 936 N2505ASims Kenneth Leon · Desert Hot Springs, CABuilt 1952 · S/N 22-816 N2505FAcme Anvil LLC · Parker, COBuilt 1965 · S/N 127 N2505KIvy James E · Alba, TXBuilt 1979 · S/N 38-79A0669 N2505MSever Jeffrey D · Anchorage, AKBuilt 1946 · S/N 12-1003 N2505RTcheutchua Romeo J · Olathe, KSBuilt 1969 · S/N 28-5638 N2505ZStratton Robert Stephen · Boulder, COFirst renewal noticeBuilt 1977 · S/N 330-77 N25062Stratton James P · Lubbock, TXBuilt 1979 · S/N 38-80A0026 N2506GInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 38-79A0547 N2506LColumbus State Community College · Columbus, OHBuilt 1979 · S/N 38-79A0740 N2506WHeiss William R · Watkins, COS/N MC-165 N2506ZKisser Karl J · Anchorage, AKBuilt 1977 · S/N 614-77 N2507Wagar Dennis Murphy · Marion, MTBuilt 2022 · S/N 5330 N2507AMann Robert M · Royal Oak, MIBuilt 1978 · S/N 38-78A0722 N2507DMurphy Robert Joseph · Galveston, TXS/N 38-79A0344 N2507KLabonte Stephen M · Gilford, NHBuilt 1968 · S/N 217 N2507MEller Ralph E · Wasilla, AKBuilt 1946 · S/N 12-1005 N2507WHoffman Ray Y · Elysburg, PARegistration revokedBuilt 1973 · S/N MC-190 N2507ZZawada John R · Wht Sphr Spgs, MTBuilt 1999 · S/N 55 N2508WBas Part Sales LLC · Greeley, COS/N MC-166 N2508ZAmelia Reid Aviation LLC · San Jose, CABuilt 1978 · S/N 1249-78 N25091Piper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-80A0029 N2509AEagle Aviation LLC · Benton, KYBuilt 1978 · S/N 38-78A0724 N2509DLong Joel A · Clinton, MOBuilt 2000 · S/N 22501 N2509PAubort Eric Y · Laguna Hills, CABuilt 1955 · S/N 22-2870 N2509RStovall Shane R · Salado, TXBuilt 1969 · S/N 28-5639 N2509ZKovach Kim A · Ocala, FLS/N 333-77 N250CHSorrell Jeffrey R · Winter Haven, FLS/N 250 N250DBJordan J Michael · Arlington, GABuilt 1980 · S/N 1 N250DSLanger Paul Hubert · Gainesville, TXBuilt 1996 · S/N 250 N250FMParagon Airplane Leasng Co · Fort Myers, FLBuilt 2022 · S/N 28020100 N250JBGuy Jeffrey · Centerburg, OHBuilt 1981 · S/N A-109 N250JFSnapp Michael D · Portland, ORBuilt 1997 · S/N 644-320-389 FB N250JGGross Jeffrey M · Bastrop, TXBuilt 2005 · S/N 81185 N250MPray Aviation Inc · Augusta, KSS/N TD-625 N250MALc Flyers LLC · Monument, ORBuilt 2003 · S/N 2243 N250MPJohanson Jason · Groveland, CAS/N 010 N250RAReynolds Darryl G · Wills Point, TXFirst renewal noticeBuilt 1975 · S/N 17266043 N250TWhite William Brian · Apex, NCBuilt 1953 · S/N 18-2364 N250WFGita Aviation LLC · Dallas, TXBuilt 1978 · S/N 28-7916088 N250ZHHatzenbeller James M · Saint Francis, WIBuilt 2017 · S/N 5582 N25104Kantorowicz Jon C · Great Falls, MTBuilt 1977 · S/N 2501 N25106Petro Jerry R · Williamsburg, VAFirst renewal noticeBuilt 1939 · S/N 1030

Back to AD 90-04-06 R1