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.

N71165Aggie Aero Enterprises LLC · Cleveland, TXBuilt 1968 · S/N 18259517 N7116QStogner Sarah E · Monahans, TXBuilt 1972 · S/N 17260416 N71178Four Forces Of Flight LLC · Orlando, FLBuilt 1968 · S/N 18259521 N7117GBaker Brady B · South Hero, VTBuilt 1969 · S/N 17258817 N71187Watermeier Daniel W · Syracuse, NEBuilt 1968 · S/N 18259524 N71188Youderian Kenneth E · Coupeville, WABuilt 1968 · S/N 18259525 N7118GRegistration Pending · Spruce Pine, ALRegistration pendingBuilt 1973 · S/N 15074613 N7118QMartin Stephen T · Green Cove Springs, FLBuilt 1972 · S/N 17260418 N7118SSanders John B DBA · Knoxville, TNBuilt 1967 · S/N 15067818 N71198Bretschneider Danny · Wichita Falls, TXBuilt 1968 · S/N 18259527 N7119FCossette Bradley J · Detroit Lakes, MNBuilt 1966 · S/N 15063719 N711FBLing Scott P · Old Saybrook, CTBuilt 1971 · S/N U20601651 N711GTRadcliff Charles · Las Vegas, NVBuilt 1969 · S/N 17258811 N711NGHummingbird Air Service · Lincoln, NES/N 18253747 N711RNGoldsmith Donald E Jr · Brandywine, MDBuilt 1973 · S/N 17702010 N711SNSkywatch Aviation LLC · French Village, MOBuilt 1965 · S/N 17253928 N711WFSmith Lot P · Grangeville, IDBuilt 1966 · S/N 15063720 N711ZHappenstance LLC · Cabot, ARBuilt 1976 · S/N 177RG0959 N71202Anderson Kyle J · Hales Corners, WIBuilt 1969 · S/N 18259529 N71203Santa Anita Inc · Kaufman, TXBuilt 1969 · S/N 18259530 N71204Northwest Alabama Aviation LLC · Tuscaloosa, ALBuilt 1969 · S/N 18259531 N7120GSky Hook Inc · Red Wing, MNBuilt 1969 · S/N 17258820 N7120QClodfelter Terry Lynn · Norwood, NCBuilt 1972 · S/N 17260420 N71213Kerr Ryan R · Mora, MNBuilt 1969 · S/N 18259534 N71216Fly By Night LLC · Tigard, ORBuilt 1969 · S/N 18259536 N7121FMartin Tricia · Tulsa, OKBuilt 1966 · S/N 15063721 N71220Kcsi Aerial Patrol Inc · Bakersfield, CABuilt 1969 · S/N 18259537 N71225Timmusair LLC · Jacksonville, FLBuilt 1969 · S/N 18259540 N71228Ryan David · Warren, OHBuilt 1969 · S/N 18259542 N7122GBirmingham Flight Center LLC · Birmingham, ALBuilt 1969 · S/N 17258822 N7123GJet & Rotor Aviation LLC · Sacramento, CABuilt 1969 · S/N 17258823 N71242Abacus Properties Inc · Port Saint Joe, FLBuilt 1969 · S/N 18259548 N71248Howell Tom F · Roseville, CAS/N 18259550 N7124QVy Aviation LLC · Gentry, ARBuilt 1972 · S/N 17260424 N71255Basham Kelly T · Mcminnville, TNBuilt 1969 · S/N 18259552 N71258Sus Manos Extendidas · Leander, TXBuilt 1969 · S/N 18259553 N7125FWerner Angela S · Grand Forks, NDBuilt 1966 · S/N 15063725 N7125GBohannan Joshua S · Rose Hill, KSFirst renewal noticeBuilt 1969 · S/N 17258825 N7125QPiedmont Flight Inc · Winston Salem, NCBuilt 1972 · S/N 17260425 N71262Lavin Keith P · Bedford, TXS/N 18259554 N7126SMartin Marty · Summerville, GABuilt 1967 · S/N 15067826 N71279Rlr Investments LLC · Fargo, NDBuilt 1969 · S/N 18259560 N7127SAbraham Curtis L · Byron, WYBuilt 1967 · S/N 15067827 N71286Registered aircraftBuilt 1969 · S/N 18259562 N71287Bogie Aviation LLC · Newton, NJBuilt 1969 · S/N 18259563 N7128GDsr Cherokee 180 LLC · Dallas, TXBuilt 1969 · S/N 17258828 N7128QAmerican Patrols Inc · Midland, TXBuilt 1972 · S/N 17260428 N7128SHart Brian Jay · San Marcos, TXBuilt 1967 · S/N 15067828 N71292Registered aircraftBuilt 1969 · S/N 18259565 N71298Belanger Patrick J Trustee · Gilroy, CAFirst renewal noticeBuilt 1969 · S/N 18259567

Back to AD 72-03-03 R3