Skip to content

Registered aircraft · 54,019

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.

N2136GCulver Deborah M · Anchorage, AKBuilt 1958 · S/N 51436 N2136QStoneman Excav Co Inc · Ashland, VABuilt 1974 · S/N 177RG0536 N2136RGibbens John L Trustee · Rock Springs, WYBuilt 1964 · S/N 18255336 N21370Garner Jan L · Fremont, OHBuilt 1972 · S/N 18261591 N21374Stratus Aviation LLC DBA · Vacaville, CABuilt 1974 · S/N 17263938 N21376Vodry John · Quilcene, WABuilt 1972 · S/N 18261596 N2137CSchmiedt Daniel M · Westminster, SCBuilt 1954 · S/N 16122 N2137DVasenden David A Trustee · Verdi, NVBuilt 1952 · S/N 7905 N2137QInternational Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N 177RG0537 N2137RFreefall Express Inc · Gardiner, NYBuilt 1964 · S/N 18255337 N2137YCullinan David · Fryeburg, MEBuilt 1962 · S/N 17249637 N2137ZAnderson Kenneth L · Anchorage, AKBuilt 1963 · S/N 18051237 N21389Registration Pending · Waldo, WIRegistration pendingBuilt 1974 · S/N 17263942 N2138SStamm Roy Peter · Woodstock, GABuilt 1975 · S/N 21061099 N2138XSpencer Douglas J · Greenwood, CABuilt 1965 · S/N 337-0038 N21393Dinelli Aviation LLC · Milton, DES/N 18261607 N21395Faignant J Brian Jr · Anchorage, AKBuilt 1972 · S/N 18261608 N21396Greers Banner Air Of Bakersfield Inc · Bakersfield, CABuilt 1972 · S/N 18261609 N2139CWilson Todd B · Newnan, GABuilt 1953 · S/N 16124 N2139FCrow Brian M · Oakesdale, WABuilt 1965 · S/N U206-0339 N2139GSoarmates LLC · Missoula, MTBuilt 1958 · S/N 51439 N2139RShaw Gregory A · West Richland, WABuilt 1964 · S/N 18255339 N2139XAerometrix LLC · Lino Lakes, MNBuilt 1965 · S/N 337-0039 N213ANCalifornia In Nice Inc DBA · San Jose, CAS/N 17272380 N213BGUpstate Flyers LLC · Woodruff, SCBuilt 1972 · S/N 18261580 N213GCEastern Stearman Inc Trustee · Leesburg, VABuilt 1978 · S/N 21062368 N213MBNational Tax Relief Inc · Riverside, CAS/N 17702282 N21401Sterling Steven G · Richland, WABuilt 1972 · S/N 18261612 N21402Hester James Timothy · Fayetteville, GABuilt 1972 · S/N 18261613 N21403Bering Capital LLC · Anchorage, AKBuilt 1974 · S/N 17263944 N21404Usglap · Fort Morgan, COBuilt 1972 · S/N 18261615 N21405Brushwood John W · Coshocton, OHBuilt 1972 · S/N 18261616 N2140CMilton William H · Amsterdam, NYS/N 16125 N2140GBoger Malcolm L · Dickens, TXBuilt 1958 · S/N 51440 N2140JHardin County Aviation LLC · Kountze, TXBuilt 1975 · S/N 17265018 N2140QAtlantic Beach Flyers LLC · Atlantic Beach, FLBuilt 1974 · S/N 177RG0540 N21414Flyboys Flying Club LLC · Pawleys Island, SCBuilt 1972 · S/N 18261624 N21416Campbell David Lloyd · Fredericksburg, TXBuilt 1972 · S/N 18261626 N2141FHill Henry M · Sleetmute, AKBuilt 1965 · S/N U206-0341 N2141GFreiheit Larry · Clinton, MOBuilt 1958 · S/N 51441 N2141QNeuman Allen D · Sanger, TXS/N 177RG0541 N21421Paul Janet K · Beaver Island, MIBuilt 1972 · S/N 18261630 N2142CSteinsvik Magne · Seattle, WABuilt 1953 · S/N 16127 N2142QLichtenberg Jeffrey L · Brookfield, MOBuilt 1974 · S/N 177RG0542 N2143SBaiocchi Ken P · San Jose, CABuilt 1975 · S/N 21061104 N21445Woody Dwain F Trustee · Lubbock, TXBuilt 1972 · S/N 18261632 N21446Ham Todd O · Opdyke, ILBuilt 1974 · S/N 17263946 N2144RButterfield Stephen · Nampa, IDS/N 18255344 N2144ZBeerle Brion J · Anchorage, AKBuilt 1963 · S/N 18051244 N21450Brant Gary E · Salisbury, PABuilt 1972 · S/N 18261637

Back to AD 87-20-03 R2