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.

N45385Steklenski Philip G · Olympia, WABuilt 1977 · S/N 177RG1117 N453BGEastern Stearman Inc Trustee · Leesburg, VAS/N 0786 N4553SMinion Air Inc · John Day, ORBuilt 1968 · S/N 18259182 N455AFN455af LLC · Toquerville, UTBuilt 1968 · S/N 17701336 N455AKBarr Scott A · Barrow, AKS/N 18260061 N45677Davidson Christopher Scott · Friant, CABuilt 1977 · S/N 177RG1126 N456BWCustom Wholesale Supply Co Inc · Odessa, TXBuilt 1975 · S/N 20700298 N456CBCollins Bruce H · Caldwell, TXBuilt 1968 · S/N 17257257 N456WDMinton Mark D · Mobile, ALBuilt 1973 · S/N 15075169 N457AESahni Irvin K · Seguin, TXBuilt 1967 · S/N 15066592 N457DLLeis Donald E · Greenville, OHBuilt 1970 · S/N 18260404 N45835Yoakam John A · North Ridgeville, OHS/N 177RG0756 N4597RSanta Cruz Airplane LLC · Santa Cruz, CABuilt 1969 · S/N 15070525 N459STMeyers Sean · Jupiter, FLBuilt 1973 · S/N 15074495 N45AMThornburg Rocky R · White Hall, ARBuilt 1964 · S/N 21058475 N45DARegistration Pending · Fairbanks, AKRegistration pendingBuilt 1969 · S/N 17258210 N45LLLangebrake Lawrence C · Saint Petersburg, FLBuilt 1966 · S/N 18257144 N45VCHoyos Luis F · Fort Pierce, FLBuilt 1964 · S/N 21058282 N45WSRandazzo Meredith · Matthews, NCBuilt 1973 · S/N 177RG0465 N46001Df Kitcar LLC · Red Oak, TXBuilt 1968 · S/N 17256980 N46003Carroll Michael L · Rochester, WABuilt 1968 · S/N 17256981 N4600LRitchie Edwin J · Katonah, NYS/N 17254595 N4600XTwo Dot Aircraft LLC · Kalispell, MTBuilt 1966 · S/N 15064650 N46011Jackson William T · Clinton, OHBuilt 1968 · S/N 17256986 N46015Leaders Flying Service LLC · Clear Lake, MNS/N 17256988 N46019La Porte Aero Club Inc · La Porte, INS/N 17256992 N4601XMast Aviation LLC · South Boston, VABuilt 1966 · S/N 15064651 N46024Garfield Joshua E · Tampa, FLBuilt 1968 · S/N 17256995 N46027Cleary Thomas J · Fairport, NYBuilt 1968 · S/N 17256997 N46028First Take Aviation LLC · Van Nuys, CABuilt 1968 · S/N 17256998 N4602WBrugueras Ralph Steven · Deer Park, WABuilt 1963 · S/N 18254662 N46030Constance Air LLC · Luthersville, GABuilt 1968 · S/N 17257000 N46031Soucy Gary J · Brewer, MEBuilt 1968 · S/N 17257001 N46047Loudermilk John A · Nashville, TNBuilt 1968 · S/N 17257010 N46054Cabirdassou Meena · Arcadia, CABuilt 1968 · S/N 17257015 N46057Flight Time Builders Inc · Memphis, TNBuilt 1968 · S/N 17257018 N4605FSterling Aviation2 Lllc · Boca Raton, FLBuilt 1966 · S/N P206-0205 N46060Registration Pending · Factoryville, PARegistration pendingBuilt 1968 · S/N 17257019 N4606XThird Coast Aircraft LLC · Mobile, ALBuilt 1966 · S/N 15064656 N46072Fly Anytime LLC · Kankakee, ILBuilt 1968 · S/N 17257025 N46078Parrish Aviation Flight Academy LLC · Southlake, TXBuilt 1968 · S/N 17257030 N4607F7 Fox LLC · Eugene, ORBuilt 1966 · S/N P206-0207 N4607XVeldhuizen Richard B · Jesup, GABuilt 1966 · S/N 15064657 N46087Range Steven V · Greenfield, ILBuilt 1968 · S/N 17257034 N4608FAdvanced Aerospace Consultants Inc · Boynton Beach, FLBuilt 1966 · S/N P206-0208 N46092Breithaupt Tracy L · Alexandria, LAS/N 17257038 N460CBScott Ts Ag-Flyin Inc · Colquitt, GABuilt 1966 · S/N P206-0206 N460WPoling Barry · Texline, TXBuilt 1965 · S/N 18256773 N46100Aerflow Inc · Jersey City, NJBuilt 1968 · S/N 17257041 N46101Patel Aman · Wesley Chapel, FLBuilt 1968 · S/N 17257042

Back to AD 72-03-03 R3