Skip to content

Registered aircraft · 54,017

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.

N4205LKay Bennie L · Brigham City, UTBuilt 1966 · S/N 17254274 N4205UCentral California Soaring Association Inc · Avenal, CABuilt 1963 · S/N 15060205 N42060Satathite Will J · Soldotna, AKBuilt 1968 · S/N 18258835 N42061Muhle Gerald A · Lincoln, NEBuilt 1974 · S/N 17264156 N42062Parker Jo K Trustee · Ardmore, OKBuilt 1974 · S/N 17264157 N42063Bailey Danny R · China Grove, NCBuilt 1968 · S/N 18258838 N42064Howell Jerry L · Searcy, ARBuilt 1968 · S/N 18258839 N42067S & M Aviation LLC · Exton, PABuilt 1968 · S/N 18258841 N42069Endres Merrick A · Riverview, FLBuilt 1968 · S/N 18258843 N4206QOsmonovich Michael · Kent, WABuilt 1971 · S/N 17260106 N42072Rempe Richard Henry · Bumpass, VABuilt 1968 · S/N 18258844 N42078Hellebuyck Ralph Charles Jr · Attica, MIBuilt 1968 · S/N 18258845 N4207LGlaude Jason T · Scarborough, MEBuilt 1966 · S/N 17254276 N4207VTeufel Gregory W · Lake Stevens, WABuilt 1948 · S/N 18563 N4207XEuroaviation Inc Trustee · KematenS/N 337-0050 N42082Fmp Energy Inc · Bryan, TXBuilt 1968 · S/N 18258847 N42084Acp Aviation LLC · Oakdale, LAS/N 18052309 N4208LHowell Jerry C · Deatsville, ALBuilt 1966 · S/N 17254277 N42094Mdn LLC · Park City, MTBuilt 1973 · S/N 18052311 N42095Cpkb · Summit, NJBuilt 1974 · S/N 17264158 N4209QLakeland Aviation Of Minocqua Inc · Minocqua, WIBuilt 1971 · S/N 17260109 N420PKSmoking Joes Terps Co · Wasilla, AKS/N U2060868 N420RFritz David W · Kerrville, TXBuilt 1979 · S/N R18200948 N420SBWayne Daryl Hall II · Wasilla, AKS/N 18052313 N420WWFlying Colors Airparts Inc · Leesburg, FLS/N 15069243 N420ZSmoking Joe'S Terps Co · Wasilla, AKS/N 30665 N42100Chamberlain Scott Alan · Payson, AZBuilt 1973 · S/N 18052314 N42105H & J LLC · Naturl Br Sta, VABuilt 1968 · S/N 18258854 N4210FOsterhouse Daniel E · Mattawan, MIBuilt 1958 · S/N 46110 N4210QKoehn Jerome D · Fairview, OKBuilt 1971 · S/N 17260110 N4210VHolman Ricardo · Pleasant Hill, ORBuilt 1948 · S/N 18566 N42111Blanchfield Christine Lizabeth · Devils Lake, NDBuilt 1974 · S/N 17264159 N42117Sturdivant Marshall J · Ellijay, GABuilt 1974 · S/N 17264160 N42118Walsh Air LLC · Live Oak, FLBuilt 1976 · S/N 177RG1088 N4211CState Of Colorado Department Of Natural Resources · Denver, COFirst renewal noticeBuilt 1979 · S/N 18503823 N4211QJwmp Air Inc · East Moriches, NYBuilt 1971 · S/N 17260111 N42120Spiegel Darren J · Chicago, ILBuilt 1968 · S/N 18258861 N42123Vandeusen Leon W III · Leslie, ARBuilt 1973 · S/N 18052320 N42124Wright Stephen A · St George, UTBuilt 1968 · S/N 18258864 N4212542125 LLC · Mercer Island, WAS/N 18052321 N42126Zrelak Patrick · Apple Valley, CABuilt 1974 · S/N 17264162 N42131Massicott David P · Friendswood, TXBuilt 1968 · S/N 18258867 N42132Witt Lawrence · Solvang, CABuilt 1968 · S/N 18258868 N42134Wilmark Anesthesia Pllc · Corpus Christi, TXBuilt 1968 · S/N 18258870 N4213LBuenrostro Paul · Burney, CAS/N 17254282 N4213QFogarty Aviation Inc · Wasilla, AKBuilt 1971 · S/N 17260113 N42141Over The Top Aviation Inc · Jonesboro, ARBuilt 1968 · S/N 18258871 N42148Rizzo Michael R · Yorba Linda, CABuilt 1968 · S/N 18258874 N4214QMms Aircraft Leasing LLC · Williamsburg, VABuilt 1971 · S/N 17260114 N4214VGat Air & Ground LLC · Norwich, NYBuilt 1948 · S/N 18570

Back to AD 87-20-03 R2