Skip to content

Registered aircraft · 20,683

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N272RARomeo Alpha Flyers Inc · Nashville, TNBuilt 1974 · S/N 17263700 N272RRGray Kerry · Monterey, CABuilt 1973 · S/N 17261914 N272SBBailey Aviation LLC · Chesapeake, VABuilt 2001 · S/N 172S8908 N272SPBlue Ryan LLC · Billings, MTBuilt 1998 · S/N 172S8016 N272TLSanders Flight Training Center · Jasper, ALS/N 17270719 N272TNReed Perry L · Mooresville, NCBuilt 1977 · S/N 17268803 N272WCCandace A Larned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 17272677 N27300Rankin Kevin J · Maryville, MOBuilt 1998 · S/N 17280551 N2730EOew Aviation LLC · Sumter, SCBuilt 1978 · S/N 17271309 N2731UKemp Gilbert A · Waterville, NYBuilt 1963 · S/N 17250331 N2732LGlenndale LLC · Jackson, MOBuilt 1967 · S/N 17255932 N2732UDavenport Jimmy J · Hayesville, NCS/N 17250332 N2733LHugelman Frank J III · Waynesville, MOBuilt 1967 · S/N 17255933 N2734URegistered aircraftBuilt 1963 · S/N 17250334 N2735UKnepper Gary E · Canby, ORBuilt 1963 · S/N 17250335 N2736LWilson Steven W · N Richlnd Hls, TXFirst renewal noticeBuilt 1967 · S/N 17255936 N2737JClair Brent · Loraine, ILBuilt 1979 · S/N 17273643 N2737LAviation Trust Co LLC Trustee · Oklahoma City, OKS/N 17255937 N2738LDemkiewicz Daniel · Houston, TXBuilt 1967 · S/N 17255938 N2738UVan Der Waal Allan L · Port Angeles, WABuilt 1963 · S/N 17250338 N2739LHall Barbara S · Burgettstown, PABuilt 1967 · S/N 17255939 N2739UN2739u Holding LLC · New Orleans, LABuilt 1963 · S/N 17250339 N273EBNorth Country Aircraft Holdings LLC · Watertown, NYBuilt 1978 · S/N 17271018 N273JFParrish Aviation Flight Academy LLC · Southlake, TXS/N 17261732 N2740LLightsey Aviation LLC · Jacksonville, FLS/N 17255940 N2740UHarowicz Richard J · Mountain Top, PABuilt 1963 · S/N 17250340 N2741UNickel Aviation LLC · Williamstown, NJBuilt 1963 · S/N 17250341 N2742LFisher Corey · Ardmore, OKBuilt 1967 · S/N 17255942 N2742UPembroke Farm LLC · Conowingo, MDBuilt 1963 · S/N 17250342 N2743LBarnes Earl E · Live Oak, FLBuilt 1967 · S/N 17255943 N2743UArmstrong John Kyle · Lovington, NMBuilt 1963 · S/N 17250343 N2744JOvation Cwa LLC · Prairie Du Sac, WIBuilt 1979 · S/N 17273644 N2744UFladager Daryl W · Peerless, MTS/N 17250344 N2744WWilhelm LLC · Denver, COFirst renewal noticeBuilt 2004 · S/N 172S9644 N2745MNfh Aviation LLC · Pikeville, KYBuilt 1999 · S/N 17280586 N2745UMidfield Aviation LLC · Caldwell, IDBuilt 1963 · S/N 17250345 N2746CChen Mark · Plano, TXBuilt 1998 · S/N 17280587 N2746LBeavers Timothy · Charlotte, NCBuilt 1967 · S/N 17255946 N2747LGuistwhite Brian K · Etters, PABuilt 1967 · S/N 17255947 N2748LCarter Reagan Tye · Beaumont, TXBuilt 1967 · S/N 17255948 N2749EB2fh Ltd · Allentown, NJBuilt 1978 · S/N 17271314 N2749LBeeker Martin J Jr · Plymouth, MIBuilt 1967 · S/N 17255949 N274GTSkogen Joseph S · Coeur D Alene, IDBuilt 1983 · S/N 172RG1141 N274MMHanzawa George DBA · Wahiawa, HIBuilt 2003 · S/N 172S9320 N2750UMartin Maximilian · Sonora, TXBuilt 1963 · S/N 17250350 N2753LMccartney Matthew T · Lake Tapps, WAS/N 17255953 N2754EGulf Coast Helicopters Inc · Pearland, TXBuilt 1978 · S/N 17271315 N2754LThompson John D · Amana, IABuilt 1967 · S/N 17255954 N2754UKirkpatrick Dan C · Little Rock, ARBuilt 1963 · S/N 17250354 N2757UUt Lightsport One LLC · Uintah, UTBuilt 1963 · S/N 17250357

Back to AD 90-06-03 R1