Skip to content

Registered aircraft · 54,017

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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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.

N45328N45328 LLC · Naples, FLS/N 15076846 N4532CHopkins Daniel E · Chandler, AZBuilt 1953 · S/N 25476 N45335Keeney Daphne C · Fairbanks, AKBuilt 1975 · S/N 15076852 N45336Kelley Joshua S · Anchorage, AKBuilt 1976 · S/N 177RG1107 N4533BHastie William B · Anchorage, AKBuilt 1955 · S/N 31432 N4533CBerwick Robert G · Sonoma, CABuilt 1953 · S/N 25477 N4533JStevens Investment Group LLC · Elsie, MIBuilt 1980 · S/N T18803745T N45341Taylor Robert S · Satsuma, ALS/N 15076857 N45342Skybound Aviation LLC · Bixby, OKBuilt 1975 · S/N 15076858 N45349Wall Johan D · Brookston, TXBuilt 1976 · S/N 177RG1109 N4534BHornung Chet R · Nikiski, AKBuilt 1955 · S/N 31433 N4534E34 Echo Group · Spring Branch, TXBuilt 1978 · S/N 17271622 N4534FSmith Peter A · Gunnison, COBuilt 1966 · S/N 185-1019 N45350Kelley Konrad E · Grant Valkaria, FLS/N 15076863 N45351Dallas Permian LLC · Mckinney, TXBuilt 1975 · S/N 15076864 N45359Clapp Edwin G III · Fargo, NDBuilt 1976 · S/N 177RG1112 N4535FRohde Allen G · Eagle River, AKBuilt 1966 · S/N 185-1021 N45361Price Gregory D · Frankfort, ILBuilt 1975 · S/N 15076874 N45364Boren James Mason · Jasper, ALBuilt 1975 · S/N 15076876 N45367Christensen Robert T · Presho, SDBuilt 1976 · S/N 177RG1113 N45375Eastern Slope Aviation Academy · North Conway, NHBuilt 1975 · S/N 15076885 N45376Jones Sharon J · Faulkton, SDFirst renewal noticeBuilt 1975 · S/N 15076886 N4537BNewsom William A · Cheraw, SCBuilt 1955 · S/N 31436 N45385Steklenski Philip G · Olympia, WABuilt 1977 · S/N 177RG1117 N4538CSelby Gerald A · Sand Springs, OKBuilt 1952 · S/N 25482 N4538EGrasshopper Flying Club Inc · Poughkeepsie, NYBuilt 1978 · S/N 17271623 N4538FLohse Teal K · Cordova, AKBuilt 1966 · S/N 185-1025 N45393Currie Grant · Hermosa Beach, CABuilt 1975 · S/N 15076900 N45395Holmgren Michael G · Kulm, NDBuilt 1975 · S/N 15076902 N45398Tundra Wolf Inc · King Salmon, AKFirst renewal noticeS/N 15076905 N453BGEastern Stearman Inc Trustee · Leesburg, VAS/N 0786 N453MCMcneil Kenneth A · Fort Meade, FLS/N 21059844 N453PTHenrie Aviation LLC · Fairfield, NJBuilt 1984 · S/N 17276262 N453WMAerostar Companies Inc · Dover, DEFirst renewal noticeBuilt 1978 · S/N R18200828 N45407Westrup Gregory W · Greensburg, INBuilt 1975 · S/N 15076908 N4541CPolsley Christopher · Galion, OHBuilt 1953 · S/N 25485 N4541FWittnebel Karl · Los Angeles, CAS/N 185-1031 N4542BWilliamson Charles F · Ocean Isle Beach, NCBuilt 1955 · S/N 31441 N4542CThomas Scott A · Groveland, CABuilt 1954 · S/N 25486 N45430Coffield Alan B · Canyon Lake, CABuilt 1975 · S/N 15076915 N45434Urban Aviation Services Inc · Paxton, MABuilt 1975 · S/N 15076917 N4543BGrandy Glen E · Placerville, CABuilt 1955 · S/N 31442 N4543CSkog Ken · Riverside, CABuilt 1952 · S/N 25487 N45446Coronel Juan M · Elk Grove, CAS/N 15076924 N45449Beckett Michael O · Roy, WAS/N 15076927 N45454Aero Flight One LLC · Peoria, AZBuilt 1975 · S/N 15076930 N45456Oakhill Aviation LLC · Wasilla, AKBuilt 1956 · S/N 33809 N45459Quirk Charles Leo · Lake Charles, LAS/N 15076934 N45467Airnolimits LLC · Palm Coast, FLBuilt 1975 · S/N 15076939 N4546CHoffman Gregory E · Fairbanks, AKBuilt 1953 · S/N 25490

Back to AD 87-20-03 R2