Skip to content

Registered aircraft · 26,231

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

N21923Averett Jeremy J · Liberty, UTS/N 15074540 N21924Berwick Mark A · Emmett, IDBuilt 1973 · S/N 15074541 N21929Holland Roy Morgan · Santa Maria, CABuilt 1973 · S/N 15074544 N2192MVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1946 · S/N 20982 N21930Bonnett Paul R · Pine Valley, CABuilt 1973 · S/N 15074545 N21936Kempf Ian J · Havana, ILS/N 15074551 N21938Harrigan Kevin T · Nova, OHBuilt 1973 · S/N 15074553 N21940Smith Jan R · Helena, MTS/N 15074555 N21942Bunk Richard A · Woodbine, MDBuilt 1973 · S/N 15074557 N2194VDitlow LLC · Kingfisher, OKBuilt 1948 · S/N 14423 N21951Mcnett Eric V · Topsham, MES/N 15074563 N21957Jack Daniel R · Jackson, CABuilt 1973 · S/N 15074567 N2195NSchrek Debra A · Long Valley, NJBuilt 1947 · S/N 12431 N21966Barrette Richard Arthur III · Warwick, RIBuilt 1973 · S/N 15074574 N21968Hubbard Brian K · Irving, TXS/N 15074576 N2196YKoelbl Aviation LLC · Whitesboro, TXBuilt 1962 · S/N 17249696 N21972Clauson Milo L · Corvallis, ORBuilt 1973 · S/N 15074580 N21975Gabbert Jeannette F · Prescott, AZBuilt 1973 · S/N 15074582 N21976Wojtowicz Diane L · Perry, NYBuilt 1973 · S/N 15074583 N2197BRegistration Pending · Toledo, OHRegistration pendingS/N 6624 N2197VBezdicek Taylor K · Auburn, WAS/N 14426 N2197YWeber Raymond E · Palmer, AKBuilt 1962 · S/N 17249697 N21980Harris Kenneth L · Greeley, COBuilt 1973 · S/N 15074586 N21981Mahoney Thomas H · Dorrance, KSS/N 15074587 N21986Corr Harvey R · Nipomo, CABuilt 1973 · S/N 15074591 N2198NShaw Thomas A Jr · Belleville, MIBuilt 1948 · S/N 12434 N2198VPorterfield Mark A · Comer, GABuilt 1948 · S/N 14427 N2198YCustard Ray · Houston, TXBuilt 1962 · S/N 17249698 N21990Mcmahan William K · Sandy Valley, NVS/N 15074594 N21997Myers Donald W II · Saint Francisville, LAS/N 15074599 N2199NSkywagon Aero LLC · Wilmington, DEBuilt 1947 · S/N 12435 N2199VSimpson Eric · College Park, MDBuilt 1948 · S/N 14428 N219BLHuizenga Bruce A · Hudsonville, MIBuilt 2006 · S/N 9252 N219RADorshorst Dustin J · Deforest, WIBuilt 1971 · S/N 15072929 N21DBStaton Riley J · Hayden, IDS/N A-232 N21DKSiegler Thomas M · Wichita, KSS/N 003DK N21EGMundell Michael D · Akron, OHS/N 98-1003 N21JWMaximus Aviation LLC · Cheyenne, WYBuilt 1946 · S/N 2358 N21LBBrosche Leo A III · Salt Springs, FLBuilt 1977 · S/N 1013 N21LS7ac Aviation LLC · Fort Worth, TXBuilt 1964 · S/N 17251817 N21MBAarons David J · Birmingham, ALBuilt 1975 · S/N 15077002 N21MMRegistration Pending · Green Oaks, ILRegistration pendingBuilt 1995 · S/N 002 N21RBBrammer Robert C · Roanoke, VAS/N 1000001 N21RPJ-Dawgs Aviation LLC · Greenville, NCS/N 17252591 N21TMMcintosh Ethan Maybury · Miramar, FLBuilt 1976 · S/N 112 N21WBPerry Aaron O · Piqua, OHS/N WEB-1 N21XRJosh Watson · Wilton, CABuilt 1986 · S/N 1 N22001Fisher Robert G Jr · Hodges, SCBuilt 1967 · S/N 15068000 N22003Hall David D · Des Moines, WAS/N 15068002 N22004Emory Robert N · Fort Mohave, AZBuilt 1938 · S/N 854

Back to AD 94-05-05 R1