Skip to content

Registered aircraft · 54,015

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.

N8508JJanssen Willis W · Ault, COBuilt 1967 · S/N 15066408 N8508S8508s LLC · Yerington, NVBuilt 1965 · S/N 18256608 N8508TLily Gold LLC · Wilmington, DEBuilt 1959 · S/N 52408 N8508UEspinosa Isaac · Kissimmee, FLBuilt 1964 · S/N 17252408 N8509BLafleur Joel A · Garden Valley, IDBuilt 1957 · S/N 36209 N8509GVictory Family Church Of Decatur Tx Inc · Decatur, TXBuilt 1965 · S/N 15062609 N850DRMooers Michael T · Haggerstown, MDBuilt 1977 · S/N 15079358 N850MGHuston Joe L · Wasilla, AKBuilt 1966 · S/N 1851085 N850WBMorris John A · Phoenix, AZBuilt 1968 · S/N 185-1350 N850YDudley Benjamin H · Wasilla, AKBuilt 1964 · S/N 17251784 N8510SBarton Andrew · Morehead City, NCBuilt 1965 · S/N 18256610 N8510UTds Property Holdings LLC · Gilmer, TXBuilt 1964 · S/N 17252410 N8511TAcute Holdings LLC · Jenks, OKBuilt 1960 · S/N 52411 N8512SDoss Jacob · Casco, MIBuilt 1965 · S/N 18256612 N8512TRegistration Pending · Odessa, TXRegistration pendingBuilt 1959 · S/N 52412 N8513BFisher Steven B · Kuna, IDS/N 36213 N8513JHurd Billy R · North Pole, AKBuilt 1967 · S/N 15066413 N8513SBeach Thomas C III · Salado, TXBuilt 1965 · S/N 18256613 N8514QAvila Robert A · Lawrence, MABuilt 1976 · S/N U20603371 N8514TCombee Ann W · Winter Haven, FLRegistration expired, pending cancellationBuilt 1959 · S/N 52414 N8514UDyck Johan · Key Largo, FLBuilt 1964 · S/N 17252414 N8514XPeck Eldon G · Grace, IDBuilt 1962 · S/N 17557114 N8515SHawkins Kenneth Roger · Globe, AZBuilt 1965 · S/N 18256615 N8515TGraham Richard · Farmingdale, NYBuilt 1959 · S/N 52415 N8516BEdson David V · Ionia, IABuilt 1957 · S/N 36216 N8516MSealane LLC · Burlingame, CABuilt 1970 · S/N 18260446 N8516SReik Thomas Donaldson Jr · New Port Richey, FLBuilt 1965 · S/N 18256616 N8517STardif Jean Y · Moorpark, CABuilt 1965 · S/N 18256617 N8517TWahl John Jr · Yelm, WABuilt 1959 · S/N 52417 N8517UNortheast Cubs LLC · Wilmington, DEBuilt 1964 · S/N 17252417 N8518GDouble Rr Holdings LLC · Dallas, TXBuilt 1965 · S/N 15062618 N8518XHepner Karl E Jr · Clifton, VABuilt 1962 · S/N 17557118 N8519GSullivan Aviation Maintenance LLC · Fayetteville, NCS/N 15062619 N8519SCinden LLC · Nashua, NHBuilt 1965 · S/N 18256619 N851AKIncline Tahoe Ventures LLC · Incline Village, NVBuilt 1980 · S/N 18504029 N851CAT&B Aero LLC · Jacksonville, FLS/N 18267851 N851DABhh Leasing #4 LLC · Pensacola, FLBuilt 1970 · S/N 32600 N851DEO'Neal Sean M · Santa Cruz, CABuilt 1980 · S/N R18201494 N851LW578 Airplane Leasing Inc · Kissimmee, FLBuilt 1968 · S/N 17257189 N851MDKiko Peter R · Dalton, OHBuilt 1956 · S/N 33514 N8520BCook Mike R · Rye, COBuilt 1957 · S/N 36220 N8520SClark Joseph D · Kilgore, TXBuilt 1965 · S/N 18256620 N8520XJohn Robert W Jr · Andrews, TXS/N P17257120 N8521BHiebert Isaac G · Hachita, NMBuilt 1957 · S/N 36221 N8522JValley Jacob A · Brewer, MEBuilt 1967 · S/N 15066422 N8522TWicklander Richard O · Spanaway, WABuilt 1959 · S/N 52422 N8522UHebbronville Machine Shop Llp · Hebbronville, TXBuilt 1964 · S/N 17252422 N8523GStephany Peter T · Umatilla, FLS/N 15062623 N8523QLifetime Adventures LLC · Bellevue, MIBuilt 1976 · S/N U20603379 N8523THorning Jason R · Seffner, FLBuilt 1959 · S/N 52423

Back to AD 87-20-03 R2