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.

N3950QDieter Jason W · Midlothian, VAS/N 17260050 N3950YCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1964 · S/N 21058450 N3951JJenani Industries LLC · La Verne, CABuilt 1966 · S/N 15065251 N3951QGarcia Larry M · Garden Valley, CABuilt 1971 · S/N 17260051 N3951YRodriguez Coppola Patricio Andres · New Orleans, LABuilt 1964 · S/N 21058451 N3952JStewarts Aircraft Service Inc · Waynesville, OHBuilt 1966 · S/N 15065252 N3952QLloyds 172 LLC · Moore, OKS/N 17260052 N3953JKearns Reno T · Jeannette, PAS/N 15065253 N3954JDroessler Anthony E · Lakota, IABuilt 1966 · S/N 15065254 N3954YStone Clifford F Jr · Corning, CABuilt 1964 · S/N 21058454 N3955JLaird Charles L · Adelanto, CABuilt 1966 · S/N 15065255 N3955LLukasik Jason D · Eagle River, AKBuilt 1966 · S/N 17254124 N3956JStriplin James R Jr · Hartford, ALBuilt 1966 · S/N 15065256 N3956YWilliams John S · Fort Walton Beach, FLBuilt 1964 · S/N 21058456 N3957JMckinnon Benjamin G · Santaquin, UTS/N 15065257 N3957QRwm Aviation LLC · Kalispell, MTBuilt 1971 · S/N 17260057 N3957YRegistration Pending · Midland, TXRegistration pendingBuilt 1964 · S/N 21058457 N3958LN3958l LLC · Honolulu, HIBuilt 1965 · S/N 17254127 N3958QFisher Gregory S · Franklin, WIBuilt 1971 · S/N 17260058 N3959JBergin Aire · Shelter Island, NYBuilt 1966 · S/N 15065259 N3959LV1vr LLC · Wilmington, DEBuilt 1966 · S/N 17254128 N3959YRabeneau Dale · Copperopolis, CABuilt 1964 · S/N 21058459 N3960QLastochka LLC · Kalispell, MTBuilt 1971 · S/N 17260060 N3960YSeals Clinton F · Warren, ORBuilt 1964 · S/N 21058460 N3961LRaya Thomas S · Porterville, CABuilt 1966 · S/N 17254130 N3961YSmith Edward C · Lecompton, KSBuilt 1964 · S/N 21058461 N3962GJoe Sanchez Farms Inc · Walnut Grove, CABuilt 1967 · S/N U206-0962 N3962JKrnavek Carl R · Dayton, TXBuilt 1966 · S/N 15065262 N3962QKalstrom William M · Ekalaka, MTBuilt 1971 · S/N 17260062 N3963LN3963l LLC · Bishop, GABuilt 1966 · S/N 17254132 N3964LAirhorse Aviation LLC · Youngstown, OHS/N 17254133 N3966JLee A Archer Jr Red Tail Youth Flying Programs Inc · New Windsor, NYBuilt 1966 · S/N 15065266 N3966LJohnston Traci L · Denver, NCBuilt 1966 · S/N 17254135 N3967JAbbott Cedric M · Buckfield, MEBuilt 1966 · S/N 15065267 N3967LJalukar Vishram · Mason City, IABuilt 1966 · S/N 17254136 N3967QPeterson Dennis E · Cambridge, MNBuilt 1971 · S/N 17260067 N3967YBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 21058467 N3968JFlying Forward LLC · New Carlisle, OHS/N 15065268 N3968LSaddler Susan J · Dayton, OHBuilt 1966 · S/N 17254137 N3968YDetray Michael S · Roy, WAFirst renewal noticeBuilt 1964 · S/N 21058468 N3969JKhleb Hub LLC · Palm Coast, FLS/N 15065269 N3969YCayce Dick Lon Jr · Longview, TXS/N 21058469 N3970GBack Country Flying Experience Inc · Kalispell, MTBuilt 1967 · S/N U206-0970 N3970LHughes William L II · Ft Worth, TXBuilt 1966 · S/N 17254139 N3970QPetree James D · Asotin, WABuilt 1971 · S/N 17260070 N3971LKenworthy Christian R · Missoula, MTS/N 17254140 N3971YLimestone County Sheriff Dept · Athens, ALBuilt 1964 · S/N 21058471 N3972GCounty Of Merced Sheriff'S Dept · Merced, CABuilt 1967 · S/N U206-0972 N3972LBerg Brian R · Mechanicsville, VABuilt 1966 · S/N 17254141 N3972QStiles Thomas · Mechanicsville, VABuilt 1971 · S/N 17260072

Back to AD 72-03-03 R3