AD 86-22-06
Registered aircraft · 163
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:86-22-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-22-06')
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:86-22-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-22-06') 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.
N276MABank Of Utah Trustee · Salt Lake City, UTN280HPTextron Aviation Inc · Wichita, KSN292BWSkyline Aviation Services LLC · Miramar, FLN2AVRegistration Pending · Scottsdale, AZRegistration pendingN32009Ecliax LLC · Craig, AKN333LDKickin Tires Aviation LLC · Lake Wales, FLN379BETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN394SFCity Wings Inc · St Thomas, VIN399TTJuliet Foxtrot LLC · Youngstown, NYN3LGTuthill James G Jr · Burr Ridge, ILN3TCRegistration Pending · Clewiston, FLRegistration pendingN404SFCity Wings Inc · St Thomas, VIN40EAEagle Air Transport Inc · Ottawa, ILN412TFBig Grand Aviation LLC · Jupiter, FLN426KMKenmore Air Harbor LLC · Kenmore, WAN430TXTexas Department Of Public Safety · Austin, TXN43CW42f LLC · Key West, FLN463DBThunderhook Air Inc · Brentwood, TNN485JRGuardian Flight LLC · Lewisville, TXN50648Lindsey Aviation Services · Haslet, TXN508RJBank Of Utah Trustee · Salt Lake City, UTN509JETwo Percent Aviation LLC · Lewes, DEN526LMBentley Raymond · Elverson, PAN543TCWonderful Orchards LLC · Shafter, CAN54CUN54cu Inc Trustee · Wilmington, DEN555DGBonnie Aero LLC · Dryden, MIN559BERegistered aircraftN569LGPacific Gas And Electric Company · Concord, CAN571SCGospel Ministries International Inc · Mc Donald, TNN5871Sparrow Group LLC · Belton, TXN593TCGarmin International Inc · Olathe, KSN59FGState Of California · Sacramento, CAN59NWScanair LLC · Dover, DEN60041Chino Farms Aviation LLC · Valley Center, CAN607TCState Of Alaska · Anchorage, AKN60WATextron Aviation Inc · Wichita, KSN611LLevesque Michael C · Hampden, MEN61WAWacouta Aircraft Leasing LLC · Las Vegas, NVN621KTDdm Aviation LLC · Coral Gables, FLN627EMMinton Air LLC · Alexandria, VAN651SDMontana Jj LLC · Big Sky, MTFirst renewal noticeN666BZCorrao Ludwig Jerome Trustee · Reno, NVN671AZPima County Board Of Supervisors · Tucson, AZN672AZPima County Board Of Supervisors · Tucson, AZN675JZMercer Fraser Co · Brookings, ORN675SMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN688MCFlight Management LLC · Kirkland, WAN6CBPk Aviation LLC · Melbourne, FLN701DLPace J C III · Fort Worth, TXN703DCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT
Back to AD 86-22-06