Skip to content

Registered aircraft · 54,015

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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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.

N7121SCashmere Aviation LLC · Mcalester, OKBuilt 1976 · S/N 18265065 N7121TSiscoe Ronald D · Bloomington, INBuilt 1959 · S/N 46721 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 N7123AMerchant Herbert M · Powhatan, VAS/N 29223 N7123GJet & Rotor Aviation LLC · Sacramento, CABuilt 1969 · S/N 17258823 N7123TDevalcourt Randall · Washington, LABuilt 1959 · S/N 46723 N71242Abacus Properties Inc · Port Saint Joe, FLBuilt 1969 · S/N 18259548 N71248Howell Tom F · Roseville, CAS/N 18259550 N7124MNelson Daniel G · Meadow, SDBuilt 1958 · S/N 55424 N7124QVy Aviation LLC · Gentry, ARBuilt 1972 · S/N 17260424 N7124TCaskey Jessica B · Anchorage, AKS/N 46724 N71255Basham Kelly T · Mcminnville, TNBuilt 1969 · S/N 18259552 N71258Sus Manos Extendidas · Leander, TXBuilt 1969 · S/N 18259553 N7125ETrinity County Sheriffs Department · Weaverville, CABuilt 1959 · S/N 52125 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 N7126AFreeman Michael D · Morgantown, INBuilt 1956 · S/N 29226 N7126EHjk Aviation LLC · Boston, MABuilt 1959 · S/N 52126 N7126MDarling Charles R · Albany, ORBuilt 1958 · S/N 55426 N7126SMartin Marty · Summerville, GABuilt 1967 · S/N 15067826 N71279Rlr Investments LLC · Fargo, NDBuilt 1969 · S/N 18259560 N7127ASeremet Cristina L · Beaver Dam, WIS/N 29227 N7127EHostetler Robert J · Windyville, MOBuilt 1959 · S/N 52127 N7127MSlinkard Andrew L · Mesa, WABuilt 1958 · S/N 55427 N7127SAbraham Curtis L · Byron, WYBuilt 1967 · S/N 15067827 N7127TLehmer Jereme · Oxford, NYBuilt 1959 · S/N 46727 N71286Registered aircraftBuilt 1969 · S/N 18259562 N71287Bogie Aviation LLC · Newton, NJBuilt 1969 · S/N 18259563 N7128AEgbert Tom · Claremore, OKBuilt 1956 · S/N 29228 N7128ESchlumpberger Charles P · Mount Shasta, CAFirst renewal noticeBuilt 1959 · S/N 52128 N7128GDsr Cherokee 180 LLC · Dallas, TXBuilt 1969 · S/N 17258828 N7128MReid Brian M · Boise, IDBuilt 1958 · S/N 55428 N7128QAmerican Patrols Inc · Midland, TXBuilt 1972 · S/N 17260428 N7128SHart Brian Jay · San Marcos, TXBuilt 1967 · S/N 15067828 N7128XSchmitt Rudy · Brookshire, TXBuilt 1961 · S/N 15059228 N71292Registered aircraftBuilt 1969 · S/N 18259565 N71298Belanger Patrick J Trustee · Gilroy, CAFirst renewal noticeBuilt 1969 · S/N 18259567 N7129FDavis Clint H · Paola, KSBuilt 1966 · S/N 15063729 N7129GSmith Lyle D · San Marcos, TXBuilt 1969 · S/N 17258829 N7129QG Alaouie LLC · Port Austin, MIBuilt 1972 · S/N 17260429 N712DAlpha Aviation LLC · Dalhart, TXBuilt 1976 · S/N 17268279 N712JFN712jf LLC · Laveen, AZBuilt 1968 · S/N 337-0859 N712TCTeasdale Gregg N · Genesee, IDBuilt 1967 · S/N 18258086 N712TTAb Cessna LLC · Wilmington, NCBuilt 1981 · S/N 17275235 N712VAwf Aviation LLC · Calera, OKBuilt 1974 · S/N 18263162

Back to AD 87-20-03 R2