AD 82-06-11 R1
Registered aircraft · 2,375
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:82-06-11-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:82-06-11-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:82-06-11-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:82-06-11-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.
N57305C And D Company LLC · Lake Park, MNN57324Richards Jeremy · Franklin, TNN57325Baker Ken C · Tehachapi, CAN57338Meyer Jerry W · Conway, ARN57343Arrow Plane Inc · Chapel Hill, NCN5743VBohm David · Walnut Creek, CAN574DSRich Joseph A · Ashtabula, OHN577EAQualitair LLC Trustee · MichelstadtN5790VJohnson James E · Calhoun, LAN579GZEuroaviation Inc Trustee · KematenN57CKCarefree Aviation LLC · Lock Haven, PAN582VWingcap LLC · Ferguson, MON584SShobe Andrew S A · Clarksville, MDN5860VAlasc Holdings LLC · Albuquerque, NMN5880VStevens Thomas G · Missoula, MTN5881VNomotsa LLC · Buena Vista, CON5892VShadbolt George · Merriman, NEN5906VL J L & D Inc · Wilmington, DEN5907VJ And K Flying Service Inc · Grand Island, NYN590JKJk Aircraft Options LLC · Aripeka, FLN590UOhio University Department Of Aviation · Albany, OHN5920VMount Ptisi LLC · Winston Salem, NCN5932VMacair Aviation LLC · Xenia, OHN5935VRzr Aviation LLC · South Jordan, UTN595MASterling Flight Training LLC · Jacksonville, FLN5967VHinton Marie Catherine · Apple Valley, CAN5983VOdonnell Richard J III · Crab Orchard, WVN598PWings 4 Higher LLC · Sunnyside, WAN59LMHunter Brian D · Scranton, IAN5DWSanderson Luann E Trustee · Lawrence, KSN6008HSwartz Selden H Jr · Jacksonville, ORN601BSThird Coast Aircraft LLC · Mobile, ALN601TGKenmore Crew Leasing Inc · Bellingham, WAN6049HTorlone A J · Carlsbad, CAN604EAExecutive Air Transport Inc · Muskegon, MIN6067HMilford Aviation Inc · Hoffman Estates, ILN6071HArrow71h LLC · Phoenix, AZN6083HAerotyne Aviation LLC · Omaha, NEN6089HGromer Gerald M · Sebastopol, CAN60SULuther Frank E · Amanda, OHN61011Inter American University Of Puerto Rico · Bayamon, PRN6116JGlobal Technical Services Inc · Fort Worth, TXN611CMMasters Charles O · Garden Ridge, TXN61260Syracuse Flight School Inc · Syracuse, NYN6136JTennessee Flight Academy LLC · Bristol, TNN6140HDiaz Jesse · Dothan, ALN614XGMaher Jay A · Highlands Ranch, CON6153JLange Scott A · Rapid City, SDN6159HJeva Ventures LLC · Charleston, SCN6161HCouture Michael E · Conway, NH
Back to AD 82-06-11 R1