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.

N6511SGby Aero LLC · Cocoa, FLS/N 15067311 N6512GParry Anthony D · Sedro Woolley, WAS/N 15072012 N6512SHaskin Jeff · Sulphur Springs, TXBuilt 1967 · S/N 15067312 N6515GNorthwest Aeroventures LLC · Steilacoom, WABuilt 1970 · S/N 15072015 N6515SMoroney Richard D · Mc Grath, MNS/N 15067315 N6516SLee Robert E · Medford, WIS/N 15067316 N65172Kfam Enterprises LLC · Dover, DES/N 17252998 N6517FSnouffer Robert E · Mountain Grove, MOBuilt 1966 · S/N 15063117 N65195Sciortino Warren A III · Crested Butte, COBuilt 1966 · S/N R1720021 N651ECEagle Sky Patrol Inc · Deadwood, SDBuilt 1967 · S/N 17700633 N651EFGrizzly Air LLC · Clearwater, FLBuilt 1967 · S/N 15067317 N65206Brinkhoff Gary H · Hygiene, COBuilt 1964 · S/N P206-0024 N6520SHighfield Carey · Vanceburg, KYBuilt 1967 · S/N 15067320 N6521GKirk James H III · Odessa, FLBuilt 1970 · S/N 15072021 N6522SAlicandro Mark B · Sebastian, FLBuilt 1967 · S/N 15067322 N6523FMatthews Mark · Brandon, MSBuilt 1966 · S/N 15063123 N6523GLee Jay S · Granite Bay, CABuilt 1970 · S/N 15072023 N6524GSantana Eric · Lehigh Acres, FLS/N 15072024 N6526FHigh Exposure Inc · Wilmington, DEBuilt 1966 · S/N 15063126 N6527SHirkala Ronald R · New Cumberland, WVBuilt 1967 · S/N 15067327 N6529FRising Aviation LLC · Prairieville, LABuilt 1966 · S/N 15063129 N6529SDemott Steve · Covina, CAS/N 15067329 N652SRBracy Rodney E · Middleville, MIBuilt 1968 · S/N 17701014 N6530FRaw Racing Inc · Puyallup, WABuilt 1966 · S/N 15063130 N6531GGalavis Eduardo · Miami, FLBuilt 1970 · S/N 15072031 N6531SHatcher Mark F · Aloha, ORBuilt 1967 · S/N 15067331 N6533FMoore William H III · Deer Park, WABuilt 1966 · S/N 15063133 N6534FAnderson Ted E · Petal, MSBuilt 1966 · S/N 15063134 N6535S315 Flight Club LLC · Fulton, NYBuilt 1967 · S/N 15067335 N6536GMessersmith Brian W · Grand Prairie, TXS/N 15072036 N6536SSohr Brian S · Oconto, WIBuilt 1967 · S/N 15067336 N6537GShettel Jay E · Boiling Springs, PAS/N 15072037 N6539FSweitzer Merle E · Felton, PABuilt 1966 · S/N 15063139 N6539GSchneider Joel · Champaign, ILBuilt 1970 · S/N 15072039 N653SRVertex Aviation Services LLC · Burlington, WABuilt 1968 · S/N 17701048 N6540GKultti Richard O · Sonoma, CABuilt 1970 · S/N 15072040 N6540SHalverson Jan T · Goldendale, WABuilt 1967 · S/N 15067340 N6541SBurke Frank E Jr · Scotland, SDBuilt 1967 · S/N 15067341 N6543FJackson Road Flyers · Wayne, MIS/N 15063143 N6545GBoomer Aviation Inc · Fort Walton Beach, FLBuilt 1971 · S/N 15072045 N6547GLarson Jerry L Jr · Shelby, MTBuilt 1970 · S/N 15072047 N6547SMiller Bradley J · Joliet, MTS/N 15067347 N6548GRoeder Paul A · Waukon, IABuilt 1970 · S/N 15072048 N6548SDersch Jonathan D · Mullica Hill, NJBuilt 1967 · S/N 15067348 N6549GAviaschin LLC · Frisco, TXBuilt 1970 · S/N 15072049 N6553SRegistration Pending · Coeur D Alene, IDRegistration pendingBuilt 1967 · S/N 15067353 N6554FMendonca Jimmy · Caddo Mills, TXBuilt 1966 · S/N 15063154 N6554GAll Bid Inc · Opelousas, LAS/N 15072054 N6555FThompson Jeffrey L · Scandia, KSS/N 15063155 N6556GBurnett Gregory D · Union, KYBuilt 1970 · S/N 15072056

Back to AD 72-03-03 R3