AD 85-11-07 R1
Registered aircraft · 471
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:85-11-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:85-11-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:85-11-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:85-11-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.
N5404WBas Part Sales LLC · Greeley, CON5405AN5405a LLC · Beverly Hills, CAN540CEEverel Airborne LLC · Sandia Park, NMN542EMRw Air LLC · Boerne, TXN5447ASchmidt Aaron B · Auburn, ALN5457AGoebel Joseph · Palos Verdes Est, CAN545STBusiness Jet Managers Inc · Canton, MIN5469XTechaero 210 LLC · Healdsburg, CAN547EMWolcott John · Peoria, AZN54CCScythe & Spade Co · Grand View, IDN54PSAustin Bill DBA · Sparta, TNN5522COswald Ron · Eden Prairie, MNN5527AMokiy LLC · Aurora, ORN5545AWhelan Peter A · Kettering, OHN5555SSky West Aviation Inc Trustee · Albuquerque, NMN55BEPenultimate 210r LLC · Cumming, GAN55EUC L Holdings LLC · Washington, DCN567DEclipse Inc · Sharon Springs, KSN56BPCeballos Oscar Felipe · San Ysidro, CAN57AMclallen Holdings LLC · Saint Charles, ILN595LTN595lt LLC · Edwards, CON5GAActon Steve · Reno, NVN600WLMoore Stan D · Amarillo, TXN6069PAirborne Helicopters LLC · Hendrum, MNN6088PSide Deck Event Management LLC · Lexington, SCN6099WGriffith Aviation Co · Tulsa, OKN60DWJohnson Boyd · Apple Valley, MNN60MKAircraft Guaranty Corp Trustee · Oklahoma City, OKN60PKWexcap Leasing LLC · Centerville, UTN60RSVolare Alto LLC · Sanford, NCN6102WPlane Blessings LLC · Montrose, CON6104ULavy Brothers Farming · Biggs, CAN611PGWrightson Properties LLC · Ft Lauderdale, FLN6122ALambeth Air LLC · Sitka, AKN6134ECf Ranch & Cattle Co LLC · Burbank, OHN6151UMccall John A · Grapeland, TXN6159ULaw Office Of Vincent G Rieger · Kalispell, MTN6178WBlu Sky Key West LLC · Key West, FLN6188USug-Air LLC · Corpus Christi, TXN61BQEle Motorsports LLC · Dover, DEN6209PFly Fast Live Slow LLC · Chiefland, FLN6262KBrz Air LLC · Beaumont, TXN627BTAviation Global Inc · Saint Augustine, FLN6280PAirborne Equipment Inc · Hendrum, MNN6290WLord Of The Wings LLC · Syracuse, NYN6294PMarkowich Darren K · Gilbert, AZN6299PDanlars Aircraft Sales · Mccall, IDN62SK55x LLC · Kalispell, MTN6300PSchrempp Aviation LLC · Winnemucca, NVN6304UHutt Aviation Inc · Minden, NV
Back to AD 85-11-07 R1