AD 71-09-07 R1
Registered aircraft · 1,686
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:71-09-07-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:71-09-07-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:71-09-07-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:71-09-07-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.
N6736RD Kevin Lester Md Inc · Fresno, CAN6737RJpk LLC · Waterloo, NEN673DKBh Aero LLC · Hanover, MNN6743RBas Part Sales LLC · Greeley, CON6745RHurt Todd A · Springfield, ORN6746RSchwartz Daniel T · Meeker, CON6749RPmbarrett Aviation LLC · Tucson, AZN6753RCooper Melvyn R Jr · Albany, GAFirst renewal noticeN6754RJarvis Ronald Louis · Gig Harbor, WAN6757RRock Air LLC · Round Mountain, NVN6759RRegistered aircraftN6761RPerini Mark J · Greenleaf, IDN6769RDomingues Silvio · Woodland, ALN6777RMarsh John E · Washington, DCN6779BRegistered aircraftN6780RC2 Aero LLC · Dallas, TXN6782RReavis Paul B · Gatesville, TXN6783RHarness Jesse J · Peoria, AZN6784RVolk Kenneth L · Waskom, TXN6785RRood Enterprises LLC · Livingston, TXN6787RJensen Leland · Idaho Falls, IDN6789RDodson International Parts Inc · Rantoul, KSN6793RDelevie Mark Y · Tucson, AZN6797RJts Management Inc · Lincoln, NEN67BL206 LLC · Keizer, ORN67CHPrestige Aviation LLC · Lake Havasu City, AZN6802RStahla Robert E Trustee · Grand Island, NEN6803RN6803r LLC · Kent, OHN6808NSwan Air LLC · Perham, MNN6816BMystic Dreams LLC · Mount Juliet, TNN6824RSquadron 5 Inc · Saratoga, CAN6826BDan Howard Aircraft Sales LLC · Tulsa, OKN6830RElizalde Carla Zankiz · Estero, FLN6832RWheeler David G Jr · Chico, CAN6843RArkansas Air LLC · Jackson, WYN6847RAlpine Aviation LLC · Oklahoma City, OKFirst renewal noticeN684MCT&B Aero LLC · Jacksonville, FLN684SSecond Wind Aviation Corp · Friday Harbor, WAN6850BJennings Donald J · Gypsum, CON6851R6851r LLC · Greeley, CON6852RJensen Sid R · Idaho Falls, IDN6855RD & N Holdings Inc · Boca Raton, FLN6857RRegistered aircraftN6859RRomeo Airmotive LLC · Stockton, CAN685GTEatmb Air Inc Trustee · Wilmington, DEN6861RJohnson Bradley Michael · Belgrade, MTN6864RRankin Bryan · Cloverdale, CAN6866ROrnes W Harold · Aiken, SCN6868RChrisman Charles Griggs · Denver, CON6870MApplied Science Services Corp · Woodland Hills, CA
Back to AD 71-09-07 R1