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.

N2518UMitchell Daniel S · Shavano Park, TXBuilt 1979 · S/N 28-8016027 N2518ZAircraft & Aviation Professionals LLC · Coldwater, MIBuilt 1977 · S/N 616-77 N25190Wiley Calvin B · Summer Shade, KYBuilt 1940 · S/N 1011 N2519BWagner Douglas L · Newbury Park, CABuilt 1984 · S/N 830 N2519PDayton Dean W · Marysville, OHBuilt 1955 · S/N 22-2881 N2519QWhite Shane A · Fayetteville, GABuilt 1991 · S/N 1155 N2519WWilliam Rainey Harper College District 512 · Palatine, ILS/N MC-194 N2519ZWatson Bobby M · Hoxie, ARBuilt 1977 · S/N 993-77 N251DBSnoopys Air Service LLC · Wappingers Falls, NYBuilt 1968 · S/N 28R-30426 N251DMBandt Johnathan Paul · South Milwaukee, WIBuilt 2000 · S/N 1284-99 N251HFHaidar Aviation LLC · Dallas, TXBuilt 2025 · S/N JP001 N251HPKoch & Koch Inc · Grass Valley, CABuilt 1982 · S/N 172RG1124 N251JBVan Horne Robert E · Centralia, ILBuilt 1965 · S/N 21 N251MANorris Suzanne W · Howe, IDBuilt 2003 · S/N 1346-2003 N251MGGeorgia Aviation Authority · Eastman, GABuilt 2021 · S/N 2881443 N251NDKasowski Flint · Buffalo, NDBuilt 1998 · S/N 2842042 N251RAReynolds Darryl G · Wills Point, TXFirst renewal noticeBuilt 1975 · S/N 17266249 N251RBNewton Roger N Jr · Marrero, LABuilt 1984 · S/N 408 N251RXPlane Therapy LLC · Hudson, FLBuilt 1978 · S/N AA5A0545 N251TGelvin Stanley M · Central, AKBuilt 1946 · S/N 12-254 N251TCTexas State Technical College · Waco, TXBuilt 2025 · S/N 28020241 N251WCThyssen Patrick L · Conroe, TXBuilt 2000 · S/N 424-2000 N251WFWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1979 · S/N 287990548 N251YAnderson Michael A · Bowie, MDBuilt 2021 · S/N M-II-2510 N2520ARaptor Flight LLC · Fort Worth, TXS/N 38-78A0730 N2520BRegistration Pending · Cheshire, CTRegistration pendingBuilt 1978 · S/N 38-79A0105 N25210Mathison John M · Vancouver, WABuilt 1977 · S/N 76 N25216Mcfarlane Claude L III · Fitchburg, WIBuilt 1977 · S/N 15280534 N2521RSok Gregory J · Wallingford, CTBuilt 1969 · S/N 28-5641 N2521SSieberts Soren K · Anchorage, AKBuilt 1979 · S/N 18-7909152 N2521UN2521u LLC · Danbury, CTBuilt 1979 · S/N 28-8016029 N25221Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280538 N25225Howard Jeff S · Anderson, SCBuilt 1977 · S/N 15280541 N25228Laguna Verde Leasing Inc · Wilmington, DES/N 15280543 N2522APierce Stephan L · Graham, TXBuilt 1953 · S/N 22-830 N2522CKlamecki Alan P · Phoenix, AZBuilt 1978 · S/N 38-79A0216 N25233Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280545 N2523AChadwick Harold T · Ottsville, PABuilt 1952 · S/N 22-829 N2523BJenny Joe S · Fresno, CABuilt 1978 · S/N 38-79A0107 N2523PHarris Jason C A · Unalakleet, AKS/N 22-2885 N2523UPro Renovations Savannah Ltd Co · Savannah, GABuilt 1979 · S/N 28-8016030 N2523ZBchr Aviation LLC · Boerne, TXBuilt 1977 · S/N 337-77 N2524FWilkins Shelley A · Claremore, OKBuilt 1966 · S/N 72 N2524MDd Leasing LLC · Aberdeen, IDBuilt 1946 · S/N 12-910 N2524UAir Warriors LLC · Opelika, ALBuilt 1979 · S/N 28-8016031 N2524WAerowave Aviation LLC · Noblesville, INBuilt 1973 · S/N MC-196 N2524ZEgan Brian M · Saint Charles, ILBuilt 1977 · S/N 338-77 N2525Davis Bill M · Kent, WABuilt 1976 · S/N 28-7790180 N25252Scott Wilson A · Norman, OKBuilt 1980 · S/N 38-80A0005 N25255Flm Aviation LLC · Vernal, UTBuilt 1977 · S/N 15280556

Back to AD 90-04-06 R1