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.

N5044EAviation Needs LLC · Stapleton, NEBuilt 1978 · S/N 17271698 N5044HCoogan Dennis P · Madison, WIBuilt 1975 · S/N 17265315 N5044RSouth Bay Flight Training Center · Carolina, PRBuilt 1974 · S/N 17263285 N50457Odyssey Entertainment Inc · Crystal, MNBuilt 1977 · S/N 177RG1133 N5045HGrabofsky Livestock & Grain Inc · Hogeland, MTBuilt 1975 · S/N 17265316 N50462Weekley Clint · Manvel, TXBuilt 1974 · S/N 17264202 N50465Howard Wayne A · Loon Lake, WABuilt 1968 · S/N 15069322 N50467Hastings Stephen J · Palmer, AKBuilt 1968 · S/N 15069324 N5046AHappy Landings Aviation LLC · Maple, NCBuilt 1955 · S/N 28046 N5046RSandpoint Aviation LLC · Sandpoint, IDS/N 18502988 N50471Honsperger Karl J Trustee · Fremont, OHBuilt 1968 · S/N 15069327 N50473Cobrinik Adam · Whites Creek, TNBuilt 1968 · S/N 15069329 N50474Mother Lode Flying Club · San Andreas, CABuilt 1968 · S/N 15069330 N50475Mc Ironworks Welding And Fabrication Inc · Chico, CABuilt 1968 · S/N 15069331 N50479Alvarez Randolph Clarence · Igiugig, AKBuilt 1974 · S/N 17264204 N5047AAeroslat4 LLC · Lewes, DEBuilt 1955 · S/N 28047 N5047DMarler Don T · Pocatello, IDBuilt 1958 · S/N 51147 N50484Freudenthal Jack J · Medford, WIBuilt 1974 · S/N 17264205 N50485Wiedeman Douglas J · Springboro, OHBuilt 1974 · S/N 17264206 N50488Fratti Robert B · Nampa, IDBuilt 1968 · S/N 15069340 N5048RSandeep Sharma LLC · Oshkosh, WIBuilt 1974 · S/N 17263289 N5048VLoewen Wielhelm · Presidio, TXBuilt 1977 · S/N R1722274 N50497Meurer Carl J · Little Rock, ARBuilt 1968 · S/N 15069347 N5049RIndiana Paging Network Inc · La Porte, INBuilt 1974 · S/N 17263290 N504JRitter Michael W · Cumberland, MDBuilt 1974 · S/N 15076142 N504JCFrequent Flyer LLC · Manasquan, NJBuilt 1973 · S/N 18502155 N504JJEdwards William A · Midland, GABuilt 1979 · S/N 17273419 N504JWPalmer Gary H · San Juan, TXBuilt 1981 · S/N 21064232 N504MAEastern Kentucky University · Richmond, KYBuilt 1983 · S/N 17275917 N504QChelatna Lake Lodge LLC · Anchorage, AKS/N U2061293 N504SDPate Charles C Trustee · Wichita, KSBuilt 1961 · S/N 18253203 N50502Behnke Randall · Manitowoc, WIS/N 15069351 N50503Kelly Keith Austin · Oklahoma City, OKBuilt 1968 · S/N 15069352 N5050ACampbell Barry A · Rogersville, TNBuilt 1955 · S/N 28050 N5051DVincent Wendal J · Geismar, LABuilt 1958 · S/N 51151 N5051RSkywarrior Flight Training LLC · Pensacola, FLBuilt 1974 · S/N 17263291 N50523Koch Allen William · Anchorage, AKBuilt 1974 · S/N 17264209 N5052DFertic Knute · Oklahoma City, OKBuilt 1958 · S/N 51152 N50530Kelly John M · Gastonia, NCBuilt 1968 · S/N 15069376 N50531Davies Patrick R · Trussville, ALBuilt 1968 · S/N 15069377 N50532Cartagena Alfonso · Winter Springs, FLBuilt 1968 · S/N 15069378 N50535Harrell Lewis H · Pontotoc, MSS/N 15069380 N50538Dunes Aircraft Corporation Inc · Howell, MIS/N 15069382 N5053AKing David · Frisco, COBuilt 1955 · S/N 28053 N5053DRancho Equipment Leasing LLC · Brownsville, TXBuilt 1958 · S/N 51153 N50541W Air LLC · Wheeling, ILBuilt 1968 · S/N 15069384 N50544Kidd Ronnie E · Ramseur, NCS/N 15069386 N5054AGrimmonpre Gary · Huntley, ILBuilt 1955 · S/N 28054 N5054DK&L Tech Inc · Adams, NEBuilt 1958 · S/N 51154 N5054HHutchins Charles L · Bayou Vista, TXBuilt 1975 · S/N 17265320

Back to AD 87-20-03 R2