Skip to content

Registered aircraft · 17,027

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

N2586LRuiz Edinson · Bakersfield, CABuilt 1967 · S/N 17255786 N2586QErrington Aero LLC · Bellefontaine, OHBuilt 1966 · S/N 18257786 N2586SCasey Aviation Inc · Mansfield, MAS/N 17252809 N2588RPoplin Tristan · Frisco, TXBuilt 1967 · S/N 18258288 N2589QMolek Eugene · Warren, OHS/N 18257789 N258KCBredesen Benjamin C · Nashville, TNBuilt 1978 · S/N 177RG1304 N2590RMason John A · Scottsdale, AZBuilt 1967 · S/N 18258290 N2591LHettenbach Paul A · Carrollton, TXBuilt 1967 · S/N 17255791 N2591QDeadmond Matthew J · Princeton, CABuilt 1966 · S/N 18257791 N2591VLivewire Holdings LLC · Salinas, CABuilt 1974 · S/N 177RG0627 N2592XLorraines Blue Sky Aviation LLC · Norman, OKBuilt 1965 · S/N P206-0092 N2593LDaly Moses M · Underhill, VTBuilt 1967 · S/N 17255793 N2593QRigoni Teresa Ann · Orting, WABuilt 1966 · S/N 18257793 N2594LSheldon Paul T · Saint James, MNBuilt 1967 · S/N 17255794 N2594QBarer Scott I · Westlake Village, CABuilt 1966 · S/N 18257794 N2595LPiper Capital Growth Fund LLC · Scottsdale, AZBuilt 1967 · S/N 17255795 N2595RDierenfeld Michael E · Northwood, IABuilt 1967 · S/N 18258295 N2596LBurris Cale · Hardin, ILBuilt 1967 · S/N 17255796 N2596QEvening Star Aviation LLC · Corvallis, ORFirst renewal noticeS/N 18257796 N2596RJones Jacob R · Rockford, TNBuilt 1967 · S/N 18258296 N2596XCarter Jason J · Athena, ORBuilt 1965 · S/N P206-0096 N2597QCattles Kenneth M Jr · Georgetown, TXBuilt 1966 · S/N 18257797 N2597RWing Frederick K · Milton, MABuilt 1967 · S/N 18258297 N2597XCavaness Gary Frank Jr · Anchorage, AKBuilt 1965 · S/N P206-0097 N2598XGilliland James H · Curwensville, PABuilt 1965 · S/N P2060098 N25AFKlik Daniel J · Washington Twp, MIBuilt 1963 · S/N 205-0418 N25AWMukherjee Kaustuv · Simsbury, CTBuilt 1961 · S/N 18253616 N25LGJolymug LLC · Saratoga, CABuilt 1975 · S/N 177RG0624 N25RTOverton Clayton J III · Sioux Falls, SDBuilt 1977 · S/N 177RG1132 N2600FZorrilla Peter · Charles Town, WVS/N 18256700 N2600LN2600l LLC · Pageland, SCBuilt 1967 · S/N 17255800 N2600QBivens Jason D · Duncan, OKBuilt 1966 · S/N 18257800 N2600ROrlandella Vito P · Auberry, CABuilt 1967 · S/N 18258300 N2601FFly3h4 LLC · Hillsboro, NDBuilt 1965 · S/N 18256701 N2601LCobb William J · Cincinnatus, NYBuilt 1967 · S/N 17255801 N2602RSiegel Jeffrey P · Snowmass Village, COS/N 18258302 N2603FHolloway Graham · Orcutt, CABuilt 1965 · S/N 18256703 N2603LMagel David J · Lakemoor, ILBuilt 1967 · S/N 17255803 N2603RHopper Jeremy G · Amity, ORS/N 18258303 N2605FRose Walter W · Arena, WIBuilt 1965 · S/N 18256705 N2606QElsayed Von Bayreuth Alaaeldeen Mohamed · Fairfield, CABuilt 1966 · S/N 18257806 N2606XSmith And Cherry Aviation LLC · Knoxville, TNBuilt 1965 · S/N P206-0106 N2608JDriftless Aero LLC · Montfort, WIBuilt 1966 · S/N 15065608 N2608QMiller David C · Burlington, CTBuilt 1966 · S/N 18257808 N2608RRegistered aircraftBuilt 1967 · S/N 18258308 N2608XOdonnell James E · Northport, NYBuilt 1965 · S/N P2060103 N2609LHavertown Flyers LLC · Havertown, PABuilt 1967 · S/N 17255809 N2609QDawson Arden H III · Eagle Nest, NMBuilt 1966 · S/N 18257809 N2610JTrotzke Samuel P · North Pole, AKBuilt 1966 · S/N 15065610 N2611FMccall Aviation LLC · Union Springs, ALBuilt 1965 · S/N 18256711

Back to AD 72-03-03 R3