Registered aircraft · 4,469

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:94-20-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:94-20-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:94-20-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:94-20-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:94-20-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:94-20-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.

N351PLifted Six Aviation LLC · Wilmington, DEBuilt 1962 · S/N D-6919 N351PLBender Cliff · Plano, ILBuilt 1964 · S/N D-7302 N351RSSmith Herschel W III Md · Roswell, GABuilt 1966 · S/N D-8299 N351VBWudtke Dale A Trustee · Palos Park, ILBuilt 1970 · S/N D-9207 N3523BSmith Terry · Atoka, TNBuilt 1954 · S/N D-3740 N3526ARoeder Miles · Houston, TXBuilt 1969 · S/N D-9075 N3526BFreeman Lyman M · Golden Hills, CABuilt 1954 · S/N D-3743 N352RHHackler Russell W Jr · Livermore, CABuilt 1964 · S/N D-7562 N353BBlair Aircraft No 2 LLC · Herriman, UTBuilt 1957 · S/N D-4971 N353RSecond Time Around Lt LLC · Corona, CAS/N D-10209 N353RGJeffrey Jacober Aviation Consultants LLC · Cherry Hill, NJBuilt 1953 · S/N D-3551 N354ALErlandsen Alan · Bremerton, WABuilt 1960 · S/N D-6570 N354DAir Repair Inc · Deadwood, SDBuilt 1964 · S/N D-7659 N354DGGaines Lawrence C · Stockton, CABuilt 1958 · S/N D-5573 N354DJN354dj LLC · Gulfport, MSBuilt 1980 · S/N D-10326 N354DPShaffer John · Virginia Beach, VABuilt 1966 · S/N D-8309 N354DRRadwanski D · Westmont, ILBuilt 1978 · S/N D-10102 N354DZDachnowicz Peter A · Avon, CTBuilt 1972 · S/N D-9336 N354FBCleared Direct LLC · Portland, ORFirst renewal noticeBuilt 1962 · S/N D-6961 N354JMountain V-Tail LLC · Denver, COS/N D-7857 N354KPTri County Flying Club Llp · Estelline, SDBuilt 1964 · S/N D-7612 N354LCDelos Anesthesia Services Pc · Barstow, CABuilt 1966 · S/N D-8161 N354MMission Aviation LLC · Billings, MTBuilt 1964 · S/N D-7516 N354PFBillen Jerome · Hodges, SCBuilt 1972 · S/N D-9313 N354ZFlorida Keys Aviation Service & Leasing LLC · Key Largo, FLBuilt 1952 · S/N D-3287 N3550BKearney Steven R · Brook, GABuilt 1954 · S/N D-3757 N3552BSignal Flow Solutions LLC · Ellis, KSBuilt 1954 · S/N D-3759 N355GRGilson Steve · Covington, LABuilt 1957 · S/N D-5328 N357DRegis Frederic · Denver, COBuilt 1967 · S/N D-8562 N357SHill V35 LLC · Nashville, TNBuilt 1967 · S/N D-8679 N357TSSmith Thomas W · Enid, OKBuilt 1951 · S/N D-2785 N358ALlewellyn Development LLC · Charlotte, NCBuilt 1978 · S/N D-10163 N358BWard Mike · Carnesville, GABuilt 1957 · S/N D-5013 N358SBolla Bruce B · San Francisco, CABuilt 1967 · S/N D-8671 N3594AFlying Fur Animal Rescue · Kintnersville, PABuilt 1969 · S/N D-9072 N359BFelder Charles G · Corcoran, CABuilt 1957 · S/N D-5049 N359ERJames Chad · Needville, TXBuilt 1978 · S/N D-10182 N359VBVictor Bravo Aviation LLC · Lincoln Park, NJS/N D-5135 N35ABElk River Aero LLC · Noel, MOBuilt 1959 · S/N D-6067 N35BCjs Aviation LLC · Methuen, MABuilt 1974 · S/N D-9588 N35BKNiemi Brian R · Monterey, CABuilt 1964 · S/N D-7685 N35BMBecker Lawrence D Md · Anacortes, WABuilt 1970 · S/N D-9191 N35BNAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1976 · S/N D-9907 N35BTMarconi Properties LLC · Westbrook, CTBuilt 1979 · S/N D-10255 N35CGComesa Service Group · Middletown, DEFirst renewal noticeBuilt 1972 · S/N D-9373 N35EKHaupt Erik · Great Barrington, MABuilt 1979 · S/N D-10238 N35ESMurphy Joel · Flowermound, TXBuilt 1965 · S/N D-7918 N35EVValiair Limited Co Trustee · Casper, WYBuilt 1954 · S/N D-3752 N35FPJohnson Deandre T · Jacksonville, FLS/N D-4831 N35GPLimon Hector Jr · Lubbock, TXBuilt 1956 · S/N D-4901

Back to AD 94-20-04 R2