Registered aircraft · 81,733

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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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:81-18-04-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
  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:81-18-04-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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.

N35821Coachair Inc · Groveland, CABuilt 1976 · S/N 177RG1056 N3582ASindelar David C · Franklin, KYBuilt 1953 · S/N 22-1857 N3582KPine Point Aviation LLC · Sartell, MNBuilt 1967 · S/N 28-23641 N35833Williams David Wayne · Ivins, UTBuilt 1976 · S/N 177RG1057 N3583ZHanneman Logan L · Fairbanks, AKBuilt 1960 · S/N 18-7373 N35849Gilliam Robert L · Islamorada, FLBuilt 1976 · S/N 177RG1060 N3584KWilliamson Conner James · Hernando, FLBuilt 1967 · S/N 28-23643 N3584MBurcham Aaron T · Soldotna, AKBuilt 1947 · S/N 12-2431 N3584PWatson Frank D · Canton, PABuilt 1955 · S/N 18-4538 N3584WSeek Stephen E · Valles Mines, MOS/N 32-478 N3584ZWildman Air LLC · Mckinney, TXBuilt 1960 · S/N 18-7374 N3585Coon Donald N · Shedd, ORBuilt 2003 · S/N 25365 N35850Willke Ronald S · Edgewood, TXBuilt 1976 · S/N 177RG1061 N35852Taylor Bruce D · Cedar Rapids, IAFirst renewal noticeS/N 177RG1062 N35858Watkins Rickar D · Roseburg, ORBuilt 1976 · S/N 177RG1063 N3585AClement Jeffrey A · Abilene, TXBuilt 1953 · S/N 20-1085 N3585MHanlin Dale E · Porter, TXBuilt 1978 · S/N 28R-7837126 N3585QLerner Daniel A · East Durham, NYBuilt 1973 · S/N 17261685 N3585WRodriquez Nat III · Odessa, TXBuilt 1966 · S/N 32-479 N35866Terry Kayla · Moulton, ALBuilt 1976 · S/N 177RG1065 N35869Cardinal Flyers LLC · Moriches, NYBuilt 1976 · S/N 177RG1067 N3586MKoskovich Thomas D · Shakopee, MNBuilt 1947 · S/N 12-2509 N35872Kurtz David Lee · Cordele, GABuilt 1976 · S/N 177RG1068 N35879Aldrich Brad · Driftwood, TXBuilt 1976 · S/N 177RG1069 N3587LVanatta J Dennis · Faribault, MNBuilt 1978 · S/N 0809 N3587QBerger Donald D · Ilwaco, WABuilt 1973 · S/N 17261687 N3587XFlynn Sean C · Torrance, CABuilt 1968 · S/N 680156 N35884Dake Tech Consulting Inc · San Dimas, CAS/N 177RG1070 N3588PLewis' Flying & Maintenance Svc Inc · Morse, LABuilt 1955 · S/N 18-4543 N3589Sale Reported · Lonoke, ARSale reported, pending cancellationBuilt 1970 · S/N 680 N35896Brads Red Eye Auto Distributing LLC · Boise, IDBuilt 2003 · S/N 87M N3589KClark Joseph D · Kilgore, TXBuilt 1967 · S/N 28-23646 N3589PNewsom Bearden And Cobb Inc DBA · Lubbock, TXBuilt 1955 · S/N 18-4544 N3589QHalfpap Rodney J · Quincy, ILBuilt 1973 · S/N 17261689 N3589WCfi Aero LLC · Riverside, CABuilt 1966 · S/N 32-484 N358BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2024 · S/N 2881806 N358BHKelley Zachary · Anchorage, AKBuilt 2019 · S/N 1028 N358BTRorabaugh Kenneth P · Sunrise, FLS/N 32-40051 N358CAFreeman Braxton L · West Lebanon, NHBuilt 1989 · S/N 2841283 N358CBHurn Farm Enterprises LLC · Grand Beach, MIBuilt 2025 · S/N 18283314 N358CFApm Leasing LLC · Casper, WYBuilt 1978 · S/N 44-7995115 N358CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281510 N358GAtp Taa LLC · Wilmington, DEBuilt 2020 · S/N 2881428 N358GWMihelebach Gustav · Lancaster, KYBuilt 2000 · S/N 358 N358JCDuran Peter F · Mesa, AZBuilt 1993 · S/N 058B N358MMatuska Douglas G · Kent, WABuilt 1999 · S/N 20913 N358MERibelin Holdings LLC · Yacolt, WABuilt 2000 · S/N 18280847 N358MKNorth Star Aviation · Mankato, MNBuilt 2022 · S/N 2881524 N358QO'Quinn Shannon L · Ridgeland, SCBuilt 2023 · S/N 42146 N358RVDerby Kevin R · Clearwater, FLBuilt 1998 · S/N 22173

Back to AD 81-18-04 R2