Skip to content

Registered aircraft · 54,021

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.

N1276VNew Horizon Aviation Inc · Warwick, RIBuilt 1984 · S/N T30300262 N12772Bell Ornithopters Flying Club Inc · Eastlake, COBuilt 1973 · S/N 17262245 N12776Oviedo Juan · Oak Point, TXBuilt 1973 · S/N 17262249 N12777Mana Kai Flying LLC · Makawao, HIBuilt 1973 · S/N 17262250 N12779Mile High Flyers Club Inc · Fort Valley, VABuilt 1973 · S/N 17262252 N1277DEllison Phillip · Castle Hayne, NCBuilt 1951 · S/N 19853 N1277FJohn D Strohsahl Pa Trustee · Fort Lauderdale, FLBuilt 1979 · S/N 17272982 N1277MWilliams Richard A · Brookhaven, GABuilt 1970 · S/N 33701277 N127826350 LLC · Yorklyn, DES/N 17702387 N12783American Patrols Inc · Midland, TXBuilt 1973 · S/N 17262256 N12789Marshall Frederic J · Rochester, NYBuilt 1973 · S/N 17262261 N1278SSac Exec LLC · Sacramento, CABuilt 1976 · S/N 18264846 N12790Cdb Group Holdings LLC · Sheridan, WYBuilt 1973 · S/N 17262262 N12791Neo Flites Flying Club Inc · Elmhurst, ILBuilt 1973 · S/N 17262263 N12793Arpey Gerard J · Colleyville, TXBuilt 1973 · S/N 17262264 N12794Mccain Michael G · Barstow, CABuilt 1973 · S/N 17262265 N12795Rl Aviation LLC · Miami, FLBuilt 1973 · S/N 17262266 N12796Skylens LLC · Hammond, LABuilt 1973 · S/N 17262267 N1279MSturdy Wings Aviation LLC · Mcpherson, KSBuilt 1975 · S/N 18264272 N1279QCerrit LLC · Helena, MTBuilt 1971 · S/N 15072579 N1279SCavu Aviation LLC · Haiku, HIBuilt 1976 · S/N 18264847 N127DDKimberlin Mark · Grants Pass, ORS/N 7040 N127EDRussell Robert Q · Genoa City, WIBuilt 1980 · S/N 15284797 N127EPAnnonsen Johnny · Dix Hills, NYBuilt 1985 · S/N 172-76481 N127ETThomas Eric C · Boise, IDBuilt 1982 · S/N 18268234 N127FRYoon Paul · Saint David, AZS/N 17275292 N127GMCorn Alley Aviation LLC · El Paso, ILBuilt 1949 · S/N 7411 N127KGardner Victoria S · Port Saint Lucie, FLBuilt 1960 · S/N 17248076 N127KDSouthmost Aviation Inc · Brownsville, TXBuilt 1976 · S/N 17267210 N127RLSkylane Of Ohio LLC · London, OHS/N 18262910 N127TJRegistration Pending · Bowersville, GARegistration pendingBuilt 1978 · S/N 18266629 N127VCSmith Von T · Chelan, WABuilt 1967 · S/N 18258041 N12801Cone Ted · Wayne, NJBuilt 1973 · S/N 17262271 N12805Bemidji Aviation Services Inc · Bemidji, MNBuilt 1973 · S/N 17262275 N1280YAutumn Crucus LLC · Cincinnati, OHS/N 15059680 N12819Stewart Todd L · Mooresville, NCS/N 17262288 N1281DSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1951 · S/N 19857 N1281MWadleigh John M · Marana, AZBuilt 1970 · S/N 33701281 N1281SChief Cornerstone LLC · Billings, MTBuilt 1976 · S/N 18264849 N12820US Aviation Group LLC · Denton, TXBuilt 1973 · S/N 17262289 N12821Hayslett Norman L · Roscoe, MOBuilt 1973 · S/N 17262290 N12822Courtney Aviation LLC · Columbia, CABuilt 1973 · S/N 17262291 N1282FRainbow River Lodge Aviation LLC · Alpine, UTS/N 18502806 N1282URutledge James K Trustee · Colfax, CABuilt 1976 · S/N 17266977 N1282YShewalter Nicholas · Frankfort, MIS/N 15059682 N12830All Sports Aviation LLC · Spokane, WABuilt 1973 · S/N 17262296 N12831Bryant Kevin L · Terry, MSBuilt 1973 · S/N 17262297 N12833Kling Aviation Inc · Friendswood, TXBuilt 1973 · S/N 17262299 N12834High Flight Academy LLC · Allison Park, PABuilt 1973 · S/N 17262300 N12836Schlemmer Diane · Roswell, GABuilt 1973 · S/N 17262301

Back to AD 87-20-03 R2