Skip to content

Registered aircraft · 17,028

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.

N8490GDodot Daniel A · Westminster, COS/N 15062590 N8490JB&K Holdings LLC · Birmingham, ALBuilt 1967 · S/N 15066390 N8490LMgg Aviation 2025 LLC · Annandale, MNBuilt 1968 · S/N 17256690 N8490MMathison John · Vancouver, WAS/N A15000190 N8490SHerring James N Jr · Nederland, COBuilt 1965 · S/N 18256590 N8490ULemons Mary A · Conner, MTBuilt 1964 · S/N 17252390 N8491GMil2atp Inc · Pikeville, NCBuilt 1966 · S/N 15062591 N8491LDeb Air Inc · Norcross, GABuilt 1968 · S/N 17256691 N8491MHollenbaugh Gerald K · Glenwood Springs, COBuilt 1970 · S/N A1500191 N8491SOgrin Kirk V · Bigfork, MTBuilt 1965 · S/N 18256591 N8491URegistration Pending · Garrettsville, OHRegistration pendingBuilt 1964 · S/N 17252391 N8491ZBoice Christopher T · Roseburg, ORBuilt 1963 · S/N 205-0491 N8492LCarey Thomas A · Carabaset Vly, MEBuilt 1968 · S/N 17256692 N8492SFlight Testers LLC · Seattle, WABuilt 1965 · S/N 18256592 N8493LBriss David S Dmd · Somerset, NJBuilt 1968 · S/N 17256693 N8494GReynolds Terry J · Phoenix, AZBuilt 1965 · S/N 15062594 N8494LHess Garrett · Fullerton, CABuilt 1968 · S/N 17256694 N8495GCorrigan John P · Denver, COBuilt 1965 · S/N 15062595 N8495JParks Ryan Alan · Newcastle, WYBuilt 1967 · S/N 15066395 N8496SOkon Randy W · Missoula, MTBuilt 1965 · S/N 18256596 N8496UChandler Donald M · Alexandria, LABuilt 1964 · S/N 17252396 N8496ZRegistered aircraftS/N 205-0496 N8497GDeacon Jeffrey A · Battle Ground, WABuilt 1965 · S/N 15062597 N8497MWenatchee Valley Barnstormers LLC · Wenatchee, WABuilt 1970 · S/N A1500197 N8497URawlins Flying Club Inc · Rawlins, WYBuilt 1964 · S/N 17252397 N8498LWestern Slope Aviators LLC · Delta, COBuilt 1968 · S/N 17256698 N8499GRyan Richard E · Atlantic, IABuilt 1965 · S/N 15062599 N8499LKennedy Christopher S · Canton, ILBuilt 1968 · S/N 17256699 N8499SGraznak Timothy C · Greeley, COBuilt 1965 · S/N 18256599 N8500GAugust Mark C · Atchison, KSBuilt 1965 · S/N 15062600 N8500JRiley Alfred E III · Norristown, PABuilt 1967 · S/N 15066400 N8501SWitschger Scott L · Albuquerque, NMBuilt 1965 · S/N 18256601 N8501UOverbaugh Gary R · Highland, UTBuilt 1964 · S/N 17252401 N8502USmitty 172 LLC · Rockford, MIBuilt 1964 · S/N 17252402 N8503GPynn David W · Gasport, NYBuilt 1965 · S/N 15062603 N8503SCub Club Inc · Toddville, IABuilt 1965 · S/N 18256603 N8504UDoug & Holly Harmon Inc · Fremont, MIBuilt 1964 · S/N 17252404 N8505JKunz Isaac A · Texarkana, TXBuilt 1967 · S/N 15066405 N8505SAir Repair Inc · Cleveland, MSBuilt 1965 · S/N 18256605 N8505USilverman Phillip E Trustee · Fullerton, CABuilt 1964 · S/N 17252405 N8506GNighthawk Air Systems Inc · Miami, FLS/N 15062606 N8506JHorning Richard H · Galion, OHS/N 15066406 N8507GCaldera Michael E · Williamsport, PABuilt 1965 · S/N 15062607 N8508JJanssen Willis W · Ault, COBuilt 1967 · S/N 15066408 N8508S8508s LLC · Yerington, NVBuilt 1965 · S/N 18256608 N8508UEspinosa Isaac · Kissimmee, FLBuilt 1964 · S/N 17252408 N8509GVictory Family Church Of Decatur Tx Inc · Decatur, TXBuilt 1965 · S/N 15062609 N8510SBarton Andrew · Morehead City, NCBuilt 1965 · S/N 18256610 N8510UTds Property Holdings LLC · Gilmer, TXBuilt 1964 · S/N 17252410 N8512SDoss Jacob · Casco, MIBuilt 1965 · S/N 18256612

Back to AD 72-03-03 R3