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.

N84339Burnt Pond Aero LLC · Ostrander, OHBuilt 1969 · S/N 17258427 N8433LHeacock Jeffrey A · Hollis, MEBuilt 1968 · S/N 17256633 N8433SGregory Ovel Lee IV · Wayzata, MNS/N 18256533 N84342Choate Aviation LLC · Summerville, SCBuilt 1969 · S/N 17258429 N84346Registration Pending · New Derry, PARegistration pendingS/N 17258433 N84347Giovannini Marco · Malibu, CABuilt 1969 · S/N 17258434 N8434LMemmi Charles D · Three Springs, PABuilt 1968 · S/N 17256634 N8434UJwa Flight School LLC · Bolingbrook, ILS/N 17252334 N8434XKopp Jeffrey L · Menomonie, WIBuilt 1961 · S/N 17248934 N84351Stanton James W · Maple, NCBuilt 1969 · S/N 17258436 N84352Boundless Aviation LLC · Kailua Kona, HIBuilt 1969 · S/N 17258437 N84358Child Michael A · Fort Worth, TXBuilt 1969 · S/N 17258440 N8435EZeller Ray G · Brookings, ORBuilt 1979 · S/N 17272200 N8435LAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 1968 · S/N 17256635 N8435SFrancis David S · Lakeside, CABuilt 1965 · S/N 18256535 N8435TThompson Dennis P · Coeur D Alene, IDS/N 52335 N8436Higgins Ryan · Hellam, PABuilt 1968 · S/N 15068436 N84365Abbott Troy D · Hollywood, MDBuilt 1969 · S/N 17258441 N84367Martin Arthur D · New Market, VABuilt 1969 · S/N 17258442 N84369Ulrich Casey M · Waldo, KSBuilt 1969 · S/N 17258444 N8436MFlabob Airport LLC · Riverside, CABuilt 1969 · S/N A1500136 N8436UClinton Aviation Corp · Clinton, ARBuilt 1964 · S/N 17252336 N8436ZFriend David A · San Anselmo, CABuilt 1963 · S/N 205-0436 N84372Madflyer55 LLC · Wilmington, DEBuilt 1973 · S/N 18261862 N84379Knox John B III · Gregory, MIBuilt 1973 · S/N 18261866 N8437GAnthem Commercial Air Services Inc · Jacksonville, FLS/N 337-0783 N8437SF & S Farms · London, OHBuilt 1965 · S/N 18256537 N8437TSaviez Paul · Horseshoe Bend, IDBuilt 1959 · S/N 52337 N8437XHanshaw Joe W · Louisa, KYBuilt 1961 · S/N 17248937 N84386Bell Motor Co · Cut Bank, MTBuilt 1969 · S/N 17258454 N8438JBlackwood Larry W · Elm Mott, TXBuilt 1967 · S/N 15066338 N8438SMartin Gregory P · Fairbanks, AKBuilt 1965 · S/N 18256538 N8438TAnderson Kevin D · Paw Paw, MIBuilt 1959 · S/N 52338 N8438UPomella Logan L · Sharon Springs, NYBuilt 1964 · S/N 17252338 N8438XThomas Marc R · Elizabethtown, PABuilt 1961 · S/N 17248938 N8438ZDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1963 · S/N 2050438 N84390Butts Desmon D · New Waverly, TXBuilt 1969 · S/N 17258456 N84391Vicknair Michael N · Owasso, OKBuilt 1969 · S/N 17258457 N84392Romeo Flying Club LLC · Leonard, MIBuilt 1969 · S/N 17258458 N84397Hernandez Karen K · Garden Valley, CABuilt 1969 · S/N 17258459 N8439GSmith Air LLC · Cascade, IDS/N U20603790 N8439SRockwell Mark L · Fairbanks, AKBuilt 1965 · S/N 18256539 N8439USeeliger Jeremy E · Pasco, WABuilt 1964 · S/N 17252339 N8439XMonson Conrad · Wasilla, AKBuilt 1961 · S/N 17248939 N843DPChoice Aviation LLC · Hamilton, MTBuilt 1969 · S/N 17258431 N843YTTrue Drilling LLC · Casper, WYBuilt 1979 · S/N 21063334 N84408Miyamoto Edward · Rio Vista, CABuilt 1969 · S/N 17258462 N8440LRoot William L Trustee · Scotia, NEBuilt 1968 · S/N 17256640 N8440SHankins David B · Salome, AZBuilt 1965 · S/N 18256540 N8440UNicholls Donald B · East Amherst, NYBuilt 1976 · S/N 15077936

Back to AD 87-20-03 R2