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.

N172DVLima Tango Aviation LLC · Mount Dora, FLBuilt 1968 · S/N 17256625 N172EGMondloch Jesse R · Freedom, WIBuilt 1964 · S/N 17252003 N172ESAero Quest LLC · Olive Branch, MSBuilt 1969 · S/N 17258019 N172FMStern Jason C · Roscoe, ILBuilt 1969 · S/N 17258008 N172FPOceanic Air LLC · Key West, FLBuilt 1971 · S/N 172-59815 N172GBAig Aeronautics LLC · Guaynabo, PRS/N 17260336 N172GCDairy Air Inc · Wyoming, PABuilt 1968 · S/N 17257234 N172GFDel Martin Lp · Spring, TXFirst renewal noticeBuilt 1965 · S/N 17252903 N172GTAileron Buzz LLC · Daytona Beach, FLBuilt 1971 · S/N 17259831 N172GXSingleton Randy V · Shippensburg, PABuilt 1965 · S/N 17252756 N172HMatusky Gregory S · Cal Nev Ari, NVBuilt 1967 · S/N 17256262 N172HLStankiewicz Adam · Merrimack, NHBuilt 1970 · S/N 17259079 N172HTAuto Outlet Of Irvington LLC · Irvington, NJS/N 17257091 N172JAPalmenteri Louis J · Rhome, TXBuilt 1966 · S/N 17254401 N172JGGroendyke Jerry G · Fort Pierce, FLBuilt 1969 · S/N 17257987 N172JLSutton Aircraft Salvage LLC · Palmer, AKS/N 17257724 N172KMenard Keith · Bellevue, TXS/N 0749 N172KCWellner Thomas B · Bremerton, WABuilt 1965 · S/N 17252649 N172KPBitzan Joseph D · Charlotte, NCBuilt 1968 · S/N 17257218 N172KRRose Kim M · Mount Vernon, OHBuilt 1965 · S/N 17252960 N172LWCrane Donald L · Kenai, AKBuilt 1967 · S/N 17255790 N172MFRhody Skyhawk Flying Club LLC · Middletown, DES/N 17258001 N172NCChase James W · Port Orange, FLS/N 17260468 N172NSWings Over Texas Holdings LLC · Denton, TXBuilt 1969 · S/N 17257968 N172PFMillard Richard A · Waverly, TNBuilt 1969 · S/N 17258891 N172PJSlykhouse Gary B · Grand Rapids, MIBuilt 1966 · S/N 17255099 N172PM98x LLC · Caddo Mills, TXS/N 17256117 N172PSSchwarzenberg Johannes · MoosburgBuilt 1967 · S/N 172-55822 N172QWRiese Jennifer P · Auburn, ALBuilt 1969 · S/N 17257999 N172SAHalbauer Peter · Hartford, WIBuilt 1969 · S/N 17258302 N172SNBukowski Robert · Hot Springs, ARBuilt 1969 · S/N 17258428 N172SSWingsleasing LLC · Wichita, KSBuilt 1972 · S/N 17260696 N172TBBelli Paul · Philadelphia, TNBuilt 1970 · S/N 17259584 N172TDSoule Clauson D · Cooperstown, NYBuilt 1970 · S/N 17258939 N172TNRegistration Pending · San Antonio, TXRegistration pendingBuilt 1966 · S/N 17255519 N172VKKatula Gerard · Pawleys Island, SCBuilt 1968 · S/N 17257009 N172VLEnce Daniel G · Saint George, UTBuilt 1964 · S/N 17251968 N172WLaraux Arthur · Bethel, AKBuilt 1971 · S/N 17260099 N172ZMoss Mark A · El Dorado, CABuilt 1969 · S/N 17258726 N1730FSpragues Aerial Spraying Inc · Courtenay, NDBuilt 1966 · S/N 17255125 N1731FHostetler Robert J · Windyville, MOBuilt 1966 · S/N 17255126 N1732FWicks Colton D · Cooper, TXBuilt 1966 · S/N 17255127 N1733FRegistered aircraftBuilt 1966 · S/N 17255128 N1734FWlb Farms LLC · Iota, LABuilt 1966 · S/N 17255129 N1735QMadden David · Bethlehem, NHBuilt 1971 · S/N 15073035 N17371Lynch Kyle R · Palmetto, FLBuilt 1972 · S/N 15073714 N17375Jts Aircraft LLC · Rock Hill, SCBuilt 1972 · S/N 15073718 N1737FVoltl Mike N · Coloma, WIS/N 17255132 N1737QWilliams Kamille N · Juneau, AKS/N 15073037 N17382Hagelstein Ele C · Sanderson, TXRegistration expired, pending cancellationBuilt 1972 · S/N 15073715

Back to AD 72-03-03 R3