Skip to content

Registered aircraft · 17,028

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:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') 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:72-03-03-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
  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:72-03-03-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
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.

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 N8435LAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 1968 · S/N 17256635 N8435SFrancis David S · Lakeside, CABuilt 1965 · S/N 18256535 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 N8437SF & S Farms · London, OHBuilt 1965 · S/N 18256537 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 N8438UPomella Logan L · Sharon Springs, NYBuilt 1964 · S/N 17252338 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 N8439SRockwell Mark L · Fairbanks, AKBuilt 1965 · S/N 18256539 N8439USeeliger Jeremy E · Pasco, WABuilt 1964 · S/N 17252339 N843DPChoice Aviation LLC · Hamilton, MTBuilt 1969 · S/N 17258431 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 N84412Sohini Vinod Rai · Lufkin, TXBuilt 1969 · S/N 17258464 N8441JAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1967 · S/N 15066341 N8441LG1 Aviation LLC · Ocala, FLBuilt 1968 · S/N 17256641 N8441ZWingman Aviation LLC · Pella, IABuilt 1963 · S/N 205-0441 N84422Dhr Investments LLC · Beaumont, TXBuilt 1969 · S/N 17258467 N84429Avz Aviation Of Tennessee Inc · Knoxville, TNBuilt 1969 · S/N 17258468 N8442GFoster Dustin · Dublin, VAS/N 15062542 N8442ZGrant Bo Allen · Lovell, WYBuilt 1963 · S/N 205-0442 N84434Russell Aerial Photography Inc · Edgewater, FLBuilt 1969 · S/N 17258469 N8443GVon Wald Enterprises LLC · Glendale, AZBuilt 1965 · S/N 15062543 N8443JThunderbolt Resourcing LLC · Warrensburg, MOBuilt 1967 · S/N 15066343 N8443UNapieralski Todd Allan · Chelsea, MIS/N 17252343 N8443ZMitchell Peter J · Concord, CABuilt 1963 · S/N 205-0443 N84440Yankee Charlie LLC · Melbourne, FLBuilt 1969 · S/N 17258472 N84449Eskridge Jonathan L · Rio Rancho, NMBuilt 1969 · S/N 17258475 N8444LRiley David R · Baltimore, MDBuilt 1968 · S/N 17256644 N8444ZBaugh Jeffery · Brigham City, UTBuilt 1963 · S/N 205-0444 N84455Green Castle Aero Club · Oxford, IABuilt 1969 · S/N 17258476 N84456Warbirds East Inc · Fairhope, ALBuilt 1969 · S/N 17258477 N84459Maddox Glen E · Bushnell, FLBuilt 1969 · S/N 17258478 N8445LCurtis Bruce G · Eugene, ORBuilt 1968 · S/N 17256645 N8445ZSegerstrom William Clark · Sunriver, ORBuilt 1963 · S/N 205-0445

Back to AD 72-03-03 R3