Registered aircraft · 10,639

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:99-01-05-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:99-01-05-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:99-01-05-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:99-01-05-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:99-01-05-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:99-01-05-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.

N35967Smith Richard D · Williamstown, OHFirst renewal noticeBuilt 1941 · S/N 6680 N3596ASjostedt Brad D · Cordova, AKBuilt 1953 · S/N 18-3026 N35979Sword Scott B · Sublimity, ORBuilt 1941 · S/N 41459 N3597AN3597a LLC · Rockford, MIS/N 18-3027 N3597PBickford Tierra L · Big Lake, AKBuilt 1955 · S/N 18-4555 N3597ZWallis Jeffrey D · Greenfield Twp, PAS/N 18-7390 N35984Cranford Billy J · Wasilla, AKBuilt 1941 · S/N 4-1465 N35985Cook Mike R · Rye, COS/N 4-1464 N35986Garst Charles L · Watson, MOBuilt 1941 · S/N 4-1468 N35988Lamb Ernest J · Catawba, NCBuilt 1941 · S/N 4-1471 N3598MOlmstead Dorothy E · Talkeetna, AKBuilt 1947 · S/N 12-2444 N35991Cook Mike R · Rye, COBuilt 1941 · S/N 4-1478 N35992Price Joel A Trustee · Bozeman, MTBuilt 1941 · S/N 4-1474 N35999Kline Paul · Brooklyn, MIBuilt 1941 · S/N 4-1483 N3599AReed John S · Wasilla, AKBuilt 1953 · S/N 18-3011 N3599ZBell Mark W · Soldotna, AKS/N 18-7393 N35FASt Louis Soaring Association · Saint Louis, MOBuilt 1964 · S/N 253291 N3600MEngler Eric M DBA · Cass City, MIS/N 12-2446 N3600PPaul Mike · Sprague, WABuilt 1955 · S/N 22-3321 N3600ZDay Charles W · Sedan, KSS/N 22-7488 N3601PCox Jay D · Perryton, TXBuilt 1955 · S/N 22-3323 N3601ZMid Atlantic Air Museum · Reading, PABuilt 1960 · S/N 22-7489 N3604AOlsen-Drye Robert C · Anchor Point, AKBuilt 1953 · S/N 22-1864 N3604MKelsey Mike O · Carey, IDBuilt 1947 · S/N 12-2453 N3604PRegistration Pending · League City, TXRegistration pendingBuilt 1955 · S/N 22-3327 N3605ARhinehart Cody R · Knob Noster, MOS/N 22-1865 N3606ZLandreth Homer W · Peoria, AZBuilt 1960 · S/N 22-7494 N3607AMassey William R · Alturas, CABuilt 1953 · S/N 22-1867 N3607MWick Air Inc · Palmer, AKBuilt 1947 · S/N 12-2516 N3608ZBingman William A · Depoe Bay, ORBuilt 1960 · S/N 22-7496 N3609ZVeal Petra L · Sterling, AKBuilt 1960 · S/N 22-7497 N360BSChampagne Patrick D · San Angelo, TXBuilt 1959 · S/N 18-6869 N360HCMountain Air Spray Co Inc · Craig, COBuilt 1952 · S/N 18-1868 N360LDJohnson John · Omaha, NEBuilt 1954 · S/N 22-2335 N3610ADid U Die Inc · Herrin, ILBuilt 1953 · S/N 22-1870 N3611MPozanac Charles J · Riverside, CABuilt 1947 · S/N 12-2543 N3612PGoundry George D · Sammamish, WABuilt 1955 · S/N 22-3338 N3613AWarren Charles J · Sarver, PABuilt 1953 · S/N 22-1873 N3613KSorenson Kenneth G · Waller, TXBuilt 1946 · S/N 22301 N3613MHall Gary L · Delta Junction, AKBuilt 1947 · S/N 12-2459 N3613PLittle Bear Air LLC · Lubbock, TXS/N 22-3339 N3615MRenfro Michael W · Bethel, AKBuilt 1947 · S/N 12-2461 N3616ARegistration Pending · Safford, AZRegistration pendingS/N 22-1876 N3616MPrince Benjamin D · Lincoln, MTBuilt 1947 · S/N 12-2462 N3616PKidd Myles · Machesney Park, ILBuilt 1955 · S/N 22-3344 N3617PPhilpott Gary D · Camden, SCBuilt 1956 · S/N 22-3723 N3619MMartinson Douglas E · Nome, AKBuilt 1947 · S/N 12-2517 N3621MLazor Ronald · Middlefield, CTBuilt 1947 · S/N 12-2470 N3621PCalkins David W · Janesville, WIBuilt 1955 · S/N 22-3354 N3622MRobinson Eric C · Palmer, AKBuilt 1947 · S/N 12-2471

Back to AD 99-01-05 R1