Skip to content

Registered aircraft · 17,028

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.

N8414JRegistered aircraftS/N 15066314 N8414LMorris Christopher J · Manor, TXBuilt 1968 · S/N 17256614 N8414UHanan Rose R · Arcata, CABuilt 1964 · S/N 17252314 N8415Marcy Arthur W · Appleton, WIBuilt 1964 · S/N 17252315 N84151Sanders George W · Cloverdale, INBuilt 1969 · S/N 17258358 N84153Spirit Air Inc · Salmon, IDBuilt 1969 · S/N 17258360 N8415MMaldonado John F · Santa Fe, NMBuilt 1969 · S/N A1500115 N84162Crosswind Aviation Of Oklahoma LLC · Stillwater, OKBuilt 1969 · S/N 17258362 N84169Roach Gene T · Frankfort, KYS/N 17258363 N8416GMetrovich Paul A · Wellsville, OHBuilt 1965 · S/N 15062516 N8416MCineflex Inc · Glen Cove, NYBuilt 1969 · S/N A1500116 N8416SSnow Ryan L · Hyrum, UTBuilt 1965 · S/N 18256516 N8416UKing J Boyd · Snover, MIBuilt 1964 · S/N 17252316 N8416ZSwamp Fox Aviation LLC · Chapin, SCS/N 205-0416 N84170Follmer Todd F · Dunwoody, GABuilt 1969 · S/N 17258364 N8417UPeninsula Aero Technology Inc · Kenai, AKBuilt 1964 · S/N 17252317 N84183Chickadee Aviation LLC · Burr Ridge, ILBuilt 1969 · S/N 17258368 N84185Harrison Gene R · Pendleton, ORS/N 17258348 N84186Gould George Jr · Bryantville, MABuilt 1969 · S/N 17258369 N8418GBravo Charlie Global LLC · Kalispell, MTBuilt 1965 · S/N 15062518 N8418SSwanson Scott R · Sulphur Springs, TXBuilt 1965 · S/N 18256518 N84190Frs & Craig Llp · Byron, GABuilt 1969 · S/N 17258371 N84193Smirnov Alexei · Fair Lawn, NJBuilt 1969 · S/N 17258372 N84194Ultra Aviation LLC · Cedar Bluff, VABuilt 1969 · S/N 17258373 N84195Norcal Flight Center LLC · Lincoln, CABuilt 1969 · S/N 17258374 N8419USweeney Building Co · Lakeview, ORS/N 17252319 N8419ZMahal Pradeep S · Warren, NJBuilt 1963 · S/N 205-0419 N841BMescalero Aviation LLC · San Antonio, TXBuilt 1967 · S/N R172-0220 N841JARicci Theodore J · Spotswood, NJBuilt 1968 · S/N 17256902 N841JLMarks Stephen M · Monument, COBuilt 1967 · S/N T210-0330 N8420LHayhurst Shane R · Winfield, PABuilt 1968 · S/N 17256620 N8420MNapier Kelly L · Linton, INS/N A1500120 N8420SBrackett Scott S · Kingman, AZS/N 18256520 N8420ZWilkerson Thomas R · Kent, WABuilt 1963 · S/N 205-0420 N84210Pm Jets LLC · Ashland, OHBuilt 1969 · S/N 17258380 N84214Planefully Obvious LLC · Oshkosh, WIBuilt 1969 · S/N 17258382 N8421USky Falcon LLC · Syracuse, NYS/N 17252321 N8421ZSchmitt Rudy · Brookshire, TXBuilt 1963 · S/N 2050421 N84221Mcknight Michael D · Marietta, GABuilt 1969 · S/N 17258384 N84224Cordes Jeffrey A · Happy Valley, ORBuilt 1969 · S/N 17258386 N84225Executive Flight Institute LLC · Murrieta, CABuilt 1969 · S/N 17258387 N84226Jackson County Aviation LLC · Sneads, FLBuilt 1969 · S/N 17258388 N84229Langenbahn Theodore John · Schoharie, NYBuilt 1969 · S/N 17258389 N8422LHubert Kim J Trustee · Eagle River, AKBuilt 1968 · S/N 17256622 N8422SPhoenix Innovations Inc · Scappoose, ORBuilt 1965 · S/N 18256522 N8422ZN8422z LLC · Farmington, NMBuilt 1963 · S/N 205-0422 N84234Mazelg Aviation LLC · Bartow, FLBuilt 1969 · S/N 17258390 N8423GCamp Derek E · Sweetwater, TNBuilt 1965 · S/N 15062523 N8423LYoung James A · Toledo, WAS/N 17256623 N8423SPatton Steven R · Wayne, OHBuilt 1965 · S/N 18256523

Back to AD 72-03-03 R3