AD 79-10-14 R1
Registered aircraft · 56,582
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
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:79-10-14-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
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:79-10-14-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') 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.
N71203Santa Anita Inc · Kaufman, TXN71204Northwest Alabama Aviation LLC · Tuscaloosa, ALN7120GSky Hook Inc · Red Wing, MNN7120QClodfelter Terry Lynn · Norwood, NCN7120TDelauder Patrick J · Terra Alta, WVN71213Kerr Ryan R · Mora, MNN71216Fly By Night LLC · Tigard, ORN7121ARoberts Calvin D · Bluebell, UTN7121FMartin Tricia · Tulsa, OKN7121SCashmere Aviation LLC · Mcalester, OKN7121TSiscoe Ronald D · Bloomington, INN71220Kcsi Aerial Patrol Inc · Bakersfield, CAN71225Timmusair LLC · Jacksonville, FLN71228Ryan David · Warren, OHN7122GBirmingham Flight Center LLC · Birmingham, ALN7123AMerchant Herbert M · Powhatan, VAN7123GJet & Rotor Aviation LLC · Sacramento, CAN7123TDevalcourt Randall · Washington, LAN71242Abacus Properties Inc · Port Saint Joe, FLN71248Howell Tom F · Roseville, CAN7124MNelson Daniel G · Meadow, SDN7124QVy Aviation LLC · Gentry, ARN7124TCaskey Jessica B · Anchorage, AKN71255Basham Kelly T · Mcminnville, TNN71258Sus Manos Extendidas · Leander, TXN7125ETrinity County Sheriffs Department · Weaverville, CAN7125FWerner Angela S · Grand Forks, NDN7125GBohannan Joshua S · Rose Hill, KSFirst renewal noticeN7125QPiedmont Flight Inc · Winston Salem, NCN71262Lavin Keith P · Bedford, TXN7126AFreeman Michael D · Morgantown, INN7126EHjk Aviation LLC · Boston, MAN7126MDarling Charles R · Albany, ORN7126SMartin Marty · Summerville, GAN71279Rlr Investments LLC · Fargo, NDN7127ASeremet Cristina L · Beaver Dam, WIN7127EHostetler Robert J · Windyville, MON7127MSlinkard Andrew L · Mesa, WAN7127SAbraham Curtis L · Byron, WYN7127TLehmer Jereme · Oxford, NYN71286Registered aircraftN71287Bogie Aviation LLC · Newton, NJN7128AEgbert Tom · Claremore, OKN7128ESchlumpberger Charles P · Mount Shasta, CAFirst renewal noticeN7128GDsr Cherokee 180 LLC · Dallas, TXN7128MReid Brian M · Boise, IDN7128QAmerican Patrols Inc · Midland, TXN7128SHart Brian Jay · San Marcos, TXN7128XSchmitt Rudy · Brookshire, TXN71292Registered aircraft
Back to AD 79-10-14 R1