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.

N26498Dodson International Parts Inc · Rantoul, KSBuilt 1988 · S/N 0836 N26499Advanced Aviation Group LLC · Frederick, MDBuilt 1999 · S/N 17280730 N2649JN2649j LLC · Palm City, FLBuilt 1998 · S/N 17280599 N2649PHoffmann Greg L · Centennial, COBuilt 1955 · S/N 22-2987 N2649WTeeter Joseph Jerald · Lisbon, OHBuilt 1966 · S/N 982 N264AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881759 N264AMX Aviation Ventures Corp · Granville, TNS/N 20-1050 N264ATAirline Transport Prof Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496088 N264CAChoice Aviation LLC · Hamilton, MTBuilt 1975 · S/N 17266035 N264CMVasquez Arthur D · Ocala, FLBuilt 1978 · S/N AA5A0588 N264CTDouglass Joyce M · Christiansburg, VABuilt 1978 · S/N 17270716 N264DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843825 N264DDSigman Aviation LLC · Pelion, SCBuilt 1997 · S/N 1098 N264DMPersons Richard A · Arroyo Grande, CAFirst renewal noticeBuilt 1988 · S/N 264 N264EBReady Aim Flyer LLC · New Castle, DEBuilt 2003 · S/N 24790 N264FAStratus Rr LLC · New Castle, DEBuilt 2026 · S/N 28020260 N264GCon-Air Aviation LLC · Queen Creek, AZBuilt 1967 · S/N 30-1633 N264JSAllen James M · Gilmanton, NHBuilt 1993 · S/N 21522 N264LWilder Paul D · Chattanooga, TNBuilt 2003 · S/N 23323 N264LSStarr Brent R · Seaside, ORBuilt 2024 · S/N 70910 N264MAShaffer John C · Talkeetna, AKBuilt 2004 · S/N 482-2004 N264MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881362 N264NDPars Avn Corp · Wilmington, DEBuilt 2000 · S/N 28-42069 N264SASundance Airport LLC · Yukon, OKBuilt 1968 · S/N 28-25258 N264TPm Aviation LLC · Missoula, MTBuilt 1953 · S/N 18-2378 N264XWignall Fred J · Newcastle, WYBuilt 2002 · S/N 2114 N26502Bugsmasher Aviation LLC · Benton, KSBuilt 1998 · S/N 17280600 N26504Vista Aviation Inc · Pacoima, CABuilt 1998 · S/N 17280601 N26507Musgrave John R · Morris, ILS/N 1958 N26508Truitt Walter V Jr · Raleigh, NCBuilt 1975 · S/N 523 N2650AKulick Douglas F · Reno, NVBuilt 1952 · S/N 22-920 N2650PGodlewski John A · Ormond Beach, FLS/N 22-2988 N2650WBrown Danny L · Wichita, KSS/N 983 N2650ZFrederick James H · Springfield, OHBuilt 1977 · S/N 1223-77 N26513Caviris Charles N · Rollinsford, NHBuilt 1940 · S/N 1854 N2651RAtls Aviation LLC · Stuart, FLBuilt 1998 · S/N 17280542 N2651WStolworthy Spencer D · Maple Valley, WABuilt 1966 · S/N 3307 N2651ZHelburg Michael L · Libby, MTS/N 1004-77 N26528Robinson Michael E · Chandler, AZBuilt 1940 · S/N 1869 N2652PInternational Air Services Inc Trustee · Carson City, NVBuilt 1955 · S/N 22-2992 N2652THart William · West Plains, MOBuilt 1971 · S/N 28-7205063 N2652VTrapp Terry Lee Trustee · The Dalles, ORBuilt 1974 · S/N 177RG0644 N2652WRegistered aircraftBuilt 1966 · S/N 3308 N26531Allred Gina D Administrator · Centre, ALBuilt 1940 · S/N 1872 N2653PKoerner Stephen F · Kankakee, ILBuilt 1955 · S/N 22-2993 N2653WDyer Perri P · Argyle, TXS/N 984 N2654ESch Aviation Inc Trustee · Sporle Kings LynnBuilt 1971 · S/N 39-93 N2654PSamson Mason H · Rives Junction, MIBuilt 1955 · S/N 22-2994 N2654VVankirwin Inc · Kinnelon, NJRegistration expired, pending cancellationBuilt 1974 · S/N 177RG0645 N2654ZAlbij3 LLC · Milton, FLBuilt 1977 · S/N 358-78

Back to AD 90-04-06 R1