Skip to content

Registered aircraft · 54,015

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.

N6901HRieser Steven E II · Baltimore, OHS/N 17265637 N6901RFritz Douglas R · Anacortes, WABuilt 1967 · S/N T210-0301 N69023Gilbert Jeffrey R · Dahlonega, GABuilt 1978 · S/N 15282441 N6902ABasher Michael H · Morehead City, NCBuilt 1956 · S/N 29002 N6902XPoules Alexander · Hope Valley, RIBuilt 1960 · S/N 17247802 N69031Lewis Garry L · Livingston, LABuilt 1978 · S/N 15282448 N69036Long Robert D · Kinston, NCBuilt 1978 · S/N 15282451 N6903AFisher Joe S · Smithville, MOBuilt 1956 · S/N 29003 N6903GShipe Jacqueline M · Louisville, TNBuilt 1970 · S/N 15072403 N6903SSchewe William · Greenville, ILS/N 15067603 N69042Poplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1978 · S/N 15282455 N69043Davidson Craig H · Heber City, UTBuilt 1978 · S/N 15282456 N69045Eburg Aero LLC · Ellensburg, WABuilt 1978 · S/N 15282457 N69047Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282459 N6904MSommers William C · Temperance, MIBuilt 1975 · S/N 18263887 N6904SKoller Rex E · Athens, ALS/N 15067604 N69053Aerofeather Aviation Inc · Suffolk, VABuilt 1978 · S/N 15282463 N6905HTang Flyer LLC · Wausau, WIBuilt 1975 · S/N 17265638 N6905SSwanson David L · Rolling Meadows, ILBuilt 1967 · S/N 15067605 N6905XWoodley Aerial Leasing LLC · Walnut, ILBuilt 1960 · S/N 17556903 N69066Lake Elmo Aero LLC · Lake Elmo, MNBuilt 1978 · S/N 15282470 N6906EArnold Gerald D · Albuquerque, NMBuilt 1959 · S/N 56406 N6906XDucharme Lynn S · Polson, MTBuilt 1960 · S/N 17247806 N69078Central Texas College · Killeen, TXBuilt 1981 · S/N 15285345 N6907GMaguire Dennis · Delaware, OHBuilt 1970 · S/N 15072407 N6907XCamp Paul L · Fort Wayne, INBuilt 1960 · S/N 17247807 N6908ACarreiro Alexander · Doral, FLBuilt 1956 · S/N 29008 N6908FFrickel Thomas L · Bristow, NEBuilt 1966 · S/N 15063508 N6908MGrant Aviation Inc · Anchorage, AKBuilt 1980 · S/N 20700672 N6909Mcgrew Aaron · Bremen, GABuilt 1958 · S/N 57514 N6909EWhite Dewayne · Yreka, CABuilt 1961 · S/N 56409 N6909FCosgriff Kevin R · Midway, KYS/N 15063509 N6909GStemper Peter L · Madison, SDBuilt 1970 · S/N 15072409 N6909RMitchell Greg · Pecos, TXBuilt 1967 · S/N T210-0309 N690DMGabriel Louis R · Crestview, FLBuilt 1969 · S/N 18259626 N690TSMartin Tony A · Kingwood, TXS/N 177RG0384 N69104Giger Janice F · Weston, ORBuilt 1978 · S/N 15282484 N6910ACook Mike R · Rye, COBuilt 1956 · S/N 29010 N6910EDakota Aircare Inc · Wagner, SDS/N 56410 N6910RDirty Birdy Aviation LLC · Silt, COBuilt 1967 · S/N T210-0310 N6910XRegistration Pending · Mcpherson, KSRegistration pendingS/N 17247810 N69110Zumbrun Dennis · Montz, LABuilt 1978 · S/N 15282488 N6911ABryson John C III · Bath, NYBuilt 1956 · S/N 29011 N6911EHannah Riley · Hillsville, VAS/N 56411 N6911FOlson Richard S · Massena, NYBuilt 1966 · S/N 15063511 N6911HHarbour Aviation LLC · Weatherford, TXBuilt 1975 · S/N 17265639 N6911SHodges John Wesley · Chesapeake, VABuilt 1967 · S/N 15067611 N6911XNorth Georgia Aviation Management Group LLC · Cumming, GABuilt 1960 · S/N 17247811 N69121Everett Rylan C · Broken Bow, NES/N 15282496 N69125Pine Hill Holdings LLC · Richmond, VABuilt 1978 · S/N 15282500

Back to AD 87-20-03 R2