Skip to content

Registered aircraft · 17,023

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.

N12077Crawley Michael P · Penn Valley, CABuilt 1965 · S/N 18255966 N12095Ciddio Mark S · Sebastopol, CABuilt 1975 · S/N 17702385 N1212MVondullen Ken A · Laplace, LABuilt 1970 · S/N 17259412 N1213LBlack Jesse M Jr · Gainesville, GABuilt 1969 · S/N 18259551 N1213RMorgan Robert · Ozark, MOBuilt 1967 · S/N 15064627 N1214QTalapanuri Gokul N · Austin, TXBuilt 1971 · S/N 15072514 N1217MFlanders John D · Saunderstown, RIBuilt 1973 · S/N 177RG0400 N1218QSale Reported · Commerce City, COSale reportedBuilt 1971 · S/N 15072518 N1219QRedeemed Flying Corps Association · Oklahoma City, OKBuilt 1971 · S/N 15072519 N121ECN121ecfllyers LLC · South Jordan, UTBuilt 1967 · S/N 17700036 N121EMRegistration Pending · Austin, TXRegistration pendingBuilt 1966 · S/N 18257784 N121GBAviation Academy LLC · Wichita, KSBuilt 1968 · S/N 17257308 N1221TOakley Scott S · Essex, MDBuilt 1970 · S/N 17259334 N1222LBoland Charles R · Blairsville, GABuilt 1969 · S/N 17258385 N1223MRussell Brian K · Phoenix, AZBuilt 1974 · S/N 177RG0504 N1223QAlbertson Alford L · Lemoore, CABuilt 1971 · S/N 15072523 N1224QEmprize LLC · Menasha, WIBuilt 1971 · S/N 15072524 N1227RRegistration Pending · Laie, HIRegistration pendingBuilt 1965 · S/N 15062347 N122FSiver Creek Capital LLC · Emery, SDS/N 21058967 N122JHValentine Terence S · Glennallen, AKBuilt 1966 · S/N R-172-0086 N122KSPt Arts LLC · Grand Rapids, MIBuilt 1966 · S/N 17255255 N122PWKal Aero Flight Instruction LLC · Mattawan, MIBuilt 1966 · S/N 17255433 N122RPWerner Bryce R · Blue Earth, MNBuilt 1966 · S/N 17254543 N122WRRangers Flying Club Inc · Eden Prairie, MNBuilt 1975 · S/N 177RG0744 N1231QMclin Robert J · Mays Landing, NJBuilt 1971 · S/N 15072531 N1232QPeres Kenneth V · Erie, PABuilt 1971 · S/N 15072532 N1233QReach For Skies LLC · San Antonio, TXS/N 15072533 N1233WDouble Crown Investments LLC · Earlsboro, OKBuilt 1970 · S/N 18260263 N1234SGale Jeremy C · Clear Lake, WIS/N 17254335 N1236QRawareo LLC · Warsaw, MOBuilt 1971 · S/N 15072536 N1237QN37gd LLC · Fort Myers, FLBuilt 1971 · S/N 15072537 N1239QFleishauer John · Trona, CABuilt 1971 · S/N 15072539 N123DLNiche Advertising Solutions Inc · Statesboro, GABuilt 1969 · S/N 18259340 N123DSDenton Farms LLC · Williamsburg, MIBuilt 1975 · S/N 17702373 N123FCCurtis James · Abilene, KSBuilt 1970 · S/N 17259182 N123JTGraham Richard A · Wichita Falls, TXBuilt 1965 · S/N T210-0019 N123LSBlackford Robert G · Summit Point, WVBuilt 1973 · S/N 177RG0334 N123PYDotson Daniel · Holly Springs, MSBuilt 1966 · S/N 17254641 N123UAwg Aviation LLC · Ainsworth, IABuilt 1968 · S/N 21059004 N123UPApache Underground And Excavating LLC · Lakeside, AZBuilt 1969 · S/N 18259985 N123VJKopp Daniel D · Buckeye, AZBuilt 1965 · S/N 18256102 N123WEFogg Britt · Springdale, ARBuilt 1974 · S/N 177RG0628 N123WGThornhill Shaun · Greenville, OHBuilt 1963 · S/N 18254997 N123ZAFlying Colors Airparts Inc · Leesburg, FLBuilt 1970 · S/N 17259361 N1241QFly Rite Aviation LLC · Fort Myers, FLBuilt 1971 · S/N 15072541 N1243SDecatur Flight Center LLC · Decatur, TXBuilt 1970 · S/N 17259355 N1246CTriplett Michael D · Eastsound, WAS/N 17702689 N1248QHeffernan Kasey C · Torrance, CAS/N 15072548 N124KAJohnson Michael Scott · Edgewood, TXBuilt 1974 · S/N 17702181 N124PJNortheast Florida Aero Club Inc · Fleming Island, FLBuilt 1964 · S/N 17252491

Back to AD 72-03-03 R3