Skip to content

Registered aircraft · 40,396

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:79-10-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2') 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:79-10-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
  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:79-10-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
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.

N737GUWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 17269414 N737GVTas Aviation Of Defiance Inc · Defiance, OHBuilt 1977 · S/N 17269415 N737GZSauk Valley Aviation Inc · Sterling, ILBuilt 1977 · S/N 17269419 N737HDNotam Aviation LLC · Portage Des Sioux, MOBuilt 1977 · S/N 17269422 N737HELaurel Highlands Aeronautical Academy · Latrobe, PABuilt 1977 · S/N 17269423 N737HGGuyair Inc · Saint Charles, MOBuilt 1977 · S/N 17269425 N737HHG A W Flying Club Corp · Palos Heights, ILBuilt 1977 · S/N 17269426 N737HJPersonal Aviation Inc · Poway, CABuilt 1977 · S/N 17269427 N737HMMeyer Raymond · Ukiah, CABuilt 1977 · S/N 17269430 N737HVSchuler Eric C · Fort Salonga, NYBuilt 1977 · S/N 17269438 N737HWCag Aircraft Holdings LLC · Crystal River, FLBuilt 1977 · S/N 17269439 N737HYSeven 4 Zulu LLC · San Diego, CABuilt 1977 · S/N 17269441 N737JHMcdermotts Letsfly LLC · Somerton, AZBuilt 1977 · S/N 17269449 N737JJAvid Aviation LLC · Gilbert, AZBuilt 1977 · S/N 17269450 N737JMMccormack June · Borrego Springs, CABuilt 1977 · S/N 17269601 N737JQPorter Timothy Charles · Bloomington, INS/N 17269456 N737JRG&M Aircraft Inc · Wheat Ridge, COBuilt 1977 · S/N 17269457 N737JUFussell Tracy L · Mc Rae, GABuilt 1977 · S/N 17269460 N737JXR&R Aero Services LLC · Eden Prairie, MNBuilt 1977 · S/N 17269463 N737JYWright Robert Gene · Kearney, MOBuilt 1977 · S/N 17269464 N737KCH & H Aviation Enterprises LLC · Fairfield, OHBuilt 1977 · S/N 17269468 N737KE247 Aviation LLC · Palm Coast, FLBuilt 1977 · S/N 17269470 N737KGRamp 106 LLC · Lynn Haven, FLBuilt 1977 · S/N 17269472 N737KJRed-Tailed Hawks Aviation Academy · Mukilteo, WAS/N 17269474 N737KMSmith Daryl N · Coventry, CTBuilt 1977 · S/N 17269477 N737KQZuidema Herbert L Trustee · Redding, CABuilt 1977 · S/N 17269480 N737KWJcil LLC · Hudsonville, MIBuilt 1977 · S/N 17269486 N737KXBroadseam Aviation LLC · Kodak E, TNS/N 17269487 N737KZNeptune Aviation Services Inc · Missoula, MTBuilt 1977 · S/N 17269489 N737LGAirborne Mgmt LLC · Dublin, OHBuilt 1977 · S/N 17269496 N737LHCenterline Aviation LLC · Fredericksburg, VABuilt 1977 · S/N 17269497 N737LKTotal Flight Aircraft Leasing LLC · Apex, NCBuilt 1977 · S/N 17269499 N737LLBreyer Michael K Trustee · Crystal Lake, ILBuilt 1977 · S/N 17269500 N737LPNorris Brent I · Camarillo, CAFirst renewal noticeBuilt 1977 · S/N 17269503 N737LREagle Home Medical Corp · Roanoke Rapids, NCBuilt 1977 · S/N 17269505 N737LXN737lx LLC · Manassas, VABuilt 1977 · S/N 17269511 N737LYN8074e LLC · Jackson, NJBuilt 1977 · S/N 17269512 N737LZMoore Steven J · West Ossipee, NHBuilt 1977 · S/N 17269513 N737MELake Elmo Aero LLC · Lake Elmo, MNS/N 17269516 N737MFCarter Flygare Inc · Sacramento, CABuilt 1977 · S/N 17269517 N737MHMls Aviation LLC · Yorba Linda, CABuilt 1978 · S/N 17271366 N737MLWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 17269522 N737MPButte Aviation Inc · Butte, MTBuilt 1977 · S/N 17269524 N737MUTrade Winds Aviation Holdings LLC · Lewes, DEBuilt 1977 · S/N 17269529 N737MYN737my LLC · Mccall, IDBuilt 1977 · S/N 17269533 N737NCGreenville Flight LLC · Greer, SCBuilt 1977 · S/N 17269402 N737NFMy Way Aviation LLC · Weston, FLBuilt 1977 · S/N 17269540 N737NGTactical Integrated Training Solutions LLC · San Antonio, TXBuilt 1977 · S/N 17269541 N737NJSutton Aircraft Salvage LLC · Palmer, AKBuilt 1977 · S/N 17269543 N737NLMoravan Gregory W · Portland, ORBuilt 1978 · S/N 17269545

Back to AD 79-10-03 R2