Skip to content

Registered aircraft · 72,001

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-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.

N201PKMininger John · Quakertown, PABuilt 1977 · S/N 24-0278 N201PNAkins Anthony · Meridian, IDBuilt 1977 · S/N 24-0302 N201PPRohrbach James S · Fort Lauderdale, FLBuilt 1979 · S/N 24-0846 N201PSEmbrey Matthew D · Murrieta, CABuilt 1977 · S/N 24-0113 N201PTWells Tony · Knob Lick, KYBuilt 1977 · S/N 24-0106 N201PVCowan George L · Scranton, SCBuilt 1977 · S/N 24-0321 N201PXNecessary Richard A Jr · Rural Hall, NCBuilt 1977 · S/N 24-0315 N201PYRandolph Paul D · Easley, SCS/N 24-0310 N201PZSmits Joel R · Crete, ILBuilt 1977 · S/N 240329 N201QAIron Wing Flying Club Inc · Shelby Township, MIBuilt 1977 · S/N 24-0317 N201QCDigital Outdoor Adertising LLC · Reno, NVS/N 24-0305 N201QEWaters Michael C · Social Circle, GABuilt 1977 · S/N 24-0343 N201QHPodd Bradley Stephen · Wilmington, NCBuilt 1977 · S/N 24-0348 N201QJDubritz Michael J · Dix Hills, NYBuilt 1977 · S/N 24-0347 N201QMNordica Group Ltd · Chicago, ILBuilt 1977 · S/N 24-0339 N201QRJennings Denise E Trustee · Fullerton, CABuilt 1977 · S/N 24-0353 N201QVJohnson Philip H · Bluffton, SCS/N 24-0355 N201QWRose James D · Fort Worth, TXS/N 24-0236 N201QXRegistration Pending · Portland, ORRegistration pendingBuilt 1977 · S/N 24-0367 N201QYJohnson Seth M · Arlington, TXBuilt 1977 · S/N 24-0357 N201QZFogle Adventure Air LLC · Neeses, SCS/N 24-0358 N201RMay Jack C · Conroe, TXBuilt 1977 · S/N 24-0203 N201RAMooney 201ra Holding LLC · San Diego, CABuilt 1982 · S/N 24-1319 N201REFowler W Kirk · Longmont, COBuilt 1977 · S/N 24-0341 N201RFMfc Corp · Washington, DCS/N 24-0135 N201RJLoyless John B · Lubbock, TXBuilt 1977 · S/N 24-0115 N201RLGmg Associates · Madison, CTBuilt 1977 · S/N 24-0143 N201RRGuthrie Edward J · Lincoln Univ, PABuilt 1977 · S/N 24-0089 N201RSWilliams Ken L · Palmer, AKBuilt 1976 · S/N 24-0062 N201RUMoore James B · Yorktown, VAS/N 24-0360 N201RWRodriguez Ricardo A · Norristown, PAS/N 24-0158 N201RYTop Shelf LLC · West Fargo, NDBuilt 1977 · S/N 24-0257 N201RZGoller Daniel M · Grass Lake, MIBuilt 1977 · S/N 24-0327 N201SAQuinn Timothy M · South Haven, MIBuilt 1977 · S/N 24-0114 N201SFOmara Michael N · Seymour, CTBuilt 1965 · S/N 28-2630 N201SGPhoturis LLC · New Carlisle, OHBuilt 1977 · S/N 24-0178 N201SKBu James · South Pasadena, CABuilt 1977 · S/N 24-0142 N201SLCooley Ben · Owensboro, KYBuilt 1977 · S/N 24-0191 N201SNBecker Dean · Sarasota, FLBuilt 1977 · S/N 24-0319 N201SQThomas John M · Lake Lure, NCBuilt 1977 · S/N 240298 N201STTillman Stephen · Jacksonville, FLBuilt 1977 · S/N 24-0201 N201SWMccrea Alice · Albuquerque, NMS/N 24-0188 N201SZRacoon Aviation LLC · San Antonio, TXS/N 24-0285 N201TMerten James F · Oshkosh, WIBuilt 1970 · S/N 186 N201TAAdams Toby R · Paris, TXBuilt 1977 · S/N 24-0291 N201TCInternational Lift Planning Inc · Anaheim, CABuilt 1977 · S/N 24-0173 N201TDHasenauer Matthew R · North Platte, NEBuilt 1977 · S/N 24-0307 N201TEBest Power Inc Trustee · Wilmington, DEBuilt 1977 · S/N 24-0289 N201TJPalmetto Moon Light Services LLC · Mount Pleasant, SCBuilt 1977 · S/N 24-0306 N201TKUp Aerospace LLC A Series Of · Georgetown, TXBuilt 1976 · S/N 24-0048

Back to AD 87-10-06 R1