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.

N6917SFly 17 Sierra LLC · Tampa, FLBuilt 1967 · S/N 15067617 N6919GSeats Frank R · Bristol, VABuilt 1970 · S/N 15072419 N691DBRvrh Ventures LLC · San Antonio, FLS/N 177RG1314 N691KMMurray Karl A · Morriston, FLFirst renewal noticeBuilt 1968 · S/N 18259427 N6921FAndrade Alexander S · Pleasant Grove, UTBuilt 1966 · S/N 15063521 N6921GWard Michael J · Carnesville, GABuilt 1970 · S/N 15072421 N6923SEpley Kennith W · Ladonia, TXBuilt 1967 · S/N 15067623 N6924RTurbo Centurion LLC · Vail, AZBuilt 1967 · S/N T210-0324 N6925FRzucidlo Trevor A · Dayville, CTBuilt 1966 · S/N 15063525 N6925RDelong Mark B · Rock Springs, WYBuilt 1967 · S/N T210-0325 N6926GWelling Michael J · Milltown, WIBuilt 1970 · S/N 15072426 N6927RSavord George Kevin · Boulder City, NVBuilt 1967 · S/N T210-0327 N6927SCendejas Agustin · Chino, CAS/N 15067627 N6928MJohnson Mark D · Onondaga, MIBuilt 1965 · S/N 15062448 N6928SPoling Brett Tyson · Saint Francis, KSBuilt 1967 · S/N 15067628 N6929Monsen Ronald · Naperville, ILBuilt 1969 · S/N 18259853 N6929FRyberg Keith C · Portales, NMBuilt 1966 · S/N 15063529 N6929RShelfer Douglas · Arlington, TXBuilt 1967 · S/N T210-0329 N692MADevine James W · Columbus, OHS/N 17700652 N6930FWright Dale D · Wallace, KSBuilt 1966 · S/N 15063530 N6931GWoody Eric · Candler, NCBuilt 1970 · S/N 15072431 N6931RFender Darrell L · Garfield, WABuilt 1967 · S/N T210-0331 N6932GRonald O Holcomb LLC · Republic, MIBuilt 1970 · S/N 15072432 N6932RBoxwell Avionics · Green Cove Springs, FLS/N T210-0332 N6933GAltomari Richard · Pittsburgh, PABuilt 1970 · S/N 15072433 N6934SLet There Be Flight LLC · Portage, MIBuilt 1967 · S/N 15067634 N6935FWood Roger E · Waxhaw, NCBuilt 1966 · S/N 15063535 N6936RKingrey William S III · Richmond, TXBuilt 1967 · S/N T210-0336 N6937FSale Reported · Rockton, ILSale reportedS/N 15063537 N6937SCaum David A · La Porte, INBuilt 1967 · S/N 15067637 N6938GRf Aviation LLC · Owensboro, KYS/N 15072438 N6939FPayne Billy Jack · Powhatan, VABuilt 1966 · S/N 15063539 N6939RGalloway Kyle J · Bradshaw, NEBuilt 1967 · S/N T210-0339 N693DADirect Action Aviation LLC · Reno, NVS/N 18259845 N6941FMorgan Stuart G · Spring Valley, CABuilt 1966 · S/N 15063541 N6941SBrowning Stephen D · Bear, DES/N 15067641 N6943GBoydston Tony C · El Paso, TXBuilt 1970 · S/N 15072443 N6943SBoniek Martin J · Nederland, COS/N 15067643 N6944RSilcox Cleven L · Sapulpa, OKBuilt 1968 · S/N T210-0344 N6944SVfr Aviation LLC · Clayton, NYS/N 15067644 N6945RDonham William David · Odessa, TXS/N T210-0345 N6946F46fox Aviation LLC · Bedminster, NJBuilt 1966 · S/N 15063546 N6946RGrosslight Gordon · Westcliffe, COBuilt 1968 · S/N T210-0346 N6946SImage Aviation Services LLC · Wilmington, DEBuilt 1967 · S/N 15067646 N6947GLin-Aero LLC · Conway, ARBuilt 1970 · S/N 15072447 N6948FLee Ethan · Millsap, TXBuilt 1966 · S/N 15063548 N6948GJbar Ranch LLC · Downey, IDBuilt 1970 · S/N 15072448 N6948SZaremba Michael W · Custer, WIBuilt 1968 · S/N 15067648 N6949FConaway Byron Richard · Savannah, TNS/N 15063549 N6949GTillstrom Gary A · Memphis, TNBuilt 1970 · S/N 15072449

Back to AD 72-03-03 R3