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.

N5600RBreland Gerald Monroe Sr · Bogalusa, LABuilt 1965 · S/N 17253207 N5603RRegistered aircraftBuilt 1965 · S/N 17253211 N5604RSkunda Robert J · Hebron, OHBuilt 1965 · S/N 17253213 N5605GMartinez Ivan A · Oro Valley, AZS/N 15071105 N5605RCostello John M · Wichita, KSBuilt 1965 · S/N 17253214 N5606GPinho Michel A · Santa Barbara, CABuilt 1969 · S/N 15071106 N560MAKrauss Solutions LLC · Debary, FLBuilt 1966 · S/N 15065142 N5610GInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 15071110 N5611RNordell Louis W · Watervliet, MIBuilt 1965 · S/N 17253222 N5612GNelson Daniel J · Ladd, ILBuilt 1969 · S/N 15071112 N5612RLoerke James S · John Day, ORBuilt 1965 · S/N 17253224 N5615GShaw Miles · Wasilla, AKS/N 17255218 N5615RWittrock Thomas L · Wiota, IABuilt 1965 · S/N 17253228 N5618RMiller Richard L · Tipp City, OHFirst renewal noticeBuilt 1965 · S/N 17253232 N561GSSandberg David C · Auke Bay, AKBuilt 1969 · S/N 15071487 N5620RVandeven Avery D · Saint Joseph, LABuilt 1965 · S/N 17253235 N5621RSale Reported · Genoa, WVSale reported, canceledBuilt 1965 · S/N 17253236 N5621XDiorio Joseph · Murrieta, CABuilt 1971 · S/N 18260796 N5622Nichols Stephen S · Hartland, WIBuilt 1966 · S/N 15065525 N5622RKv Enterprises LLC · Kalispell, MTBuilt 1965 · S/N 17253238 N5626GGreer Management LLC · Salem, ORBuilt 1969 · S/N 15071126 N5627RBitikofer Brent E · Kansas City, KSBuilt 1965 · S/N 17253245 N5628GJewell Jonathan T · Paducah, KYBuilt 1969 · S/N 15071128 N5628RKellam Garnett A · Mappsville, VABuilt 1965 · S/N 17253247 N5629RSadie Hawk Aviation LLC · Collinsville, CTBuilt 1965 · S/N 17253248 N562GSHermann Andrew L · Kindred, NDBuilt 1969 · S/N 15071509 N5630RLanas Flying Machine LLC · Hollywood, FLBuilt 1965 · S/N 17253249 N5633RBirds Eye View LLC · Nampa, IDBuilt 1965 · S/N 17253253 N5636RSkyhawk Aviation LLC · Ogden, UTBuilt 1965 · S/N 17253258 N5638RBurkhart Andrew · Toccoa, GABuilt 1965 · S/N 17253261 N5639RKeith L S · Forestburg, TXBuilt 1965 · S/N 17253262 N563FSPatterson Marshall S · Tuscumbia, ALBuilt 1967 · S/N 15066188 N563GMarsh Matthew · Cleveland, ALBuilt 1968 · S/N 15068275 N563GSGilderhus Edwin T · Oberon, NDS/N 15071468 N563RSRaven Bryan F · Lakeland, FLS/N 17255866 N5640RUnruh Jerel W · Versailles, MOBuilt 1965 · S/N 17253264 N5641REaton Samuel D · Clinton, PABuilt 1965 · S/N 17253265 N5642RMatheny Roger P · Humble, TXBuilt 1965 · S/N 17253266 N5644RShaffer Mark J · Porterfield, WIBuilt 1965 · S/N 17253269 N5645RGecha Brian S · Brandon, VTBuilt 1965 · S/N 17253270 N5646RAumack Bryant D · Melbourne, FLBuilt 1965 · S/N 17253272 N5648RKurtz Richard G · Ithaca, NYS/N 17253275 N564DSLopez John · Prole, IAS/N 15066564 N564GHughes Ramzi S · Alamo, NVBuilt 1968 · S/N 15068276 N564QLSimcic Kathryn C · Grain Valley, MOBuilt 1969 · S/N 15070570 N5651RChickasha Wings Inc · Chickasha, OKBuilt 1965 · S/N 17253279 N5653GCavanaugh Joseph Rex · Alvin, TXBuilt 1969 · S/N 15071153 N5654GNorman Charles E · Zanesville, OHBuilt 1969 · S/N 15071154 N5654RSudbrink Charles D · Willet, NYS/N 17253283 N5655GAnderson Kevin G · Pleasant Hill, CABuilt 1969 · S/N 15071155

Back to AD 72-03-03 R3