AD 84-10-01 R1
Registered aircraft · 20,481
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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.
N531ACCulwell Michael Fredrick · Vestavia Hills, ALN5320BKinze Hon K · Anchorage, AKN53214Westbank Fishing LLC · Kiln, MSN5323SGrig Aero LLC · Tulsa, OKN5323URio Farms LLC · King City, CAN5325BHinman Joshua D · Arcadia, CAN5325YBeehive Telephone Co Inc Nevada · Lake Point, UTN5326BBoatman Charles L · La Porte, TXN5326DHiebert Nathan D · Newton, KSN5327DPiekarski John S · Wichita Falls, TXN5328BUninsured Swope 182 LLC · Kalispell, MTN5329DMeketa Ann M · La Vernia, TXN5329SAlabama Forestry Commission · Montgomery, ALN532DCDc Aviation LLC · Panama City, FLN5330EKrieger Andy G · Katy, TXN5330NMarion Michael · Canyon Country, CAN53310Lucente Michael A · Fort Myers, FLN5332DLeibovitz Joshua · Portland, ORN5334BNyabenga Air LLC · Brentwood, CAN5335NRaymond Larry D · Ennis, TXN5336BYellowstone Overflight Inc · Belgrade, MTN5336HEnergy Transfer Aviation LLC · Spring, TXN5336NFischer Joseph A Jr · Lake Jackson, TXN5336YBlue Sky Inc · Lone Rock, IAN5337BSkydive Inc · Eagle Creek, ORN5337YClement Aviation Inc · Tea, SDN5338AThompson Richard T · Wilmington, OHN5338UWatermelon Packer Ll · Mcallen, TXN5339NMaine State Police · Augusta, MEN533KAKamaka Air LLC · Honolulu, HIN533TDChristopher Schultheis Inc · Colton, WAN5340XAgvest LLC · Abingdon, VAN5340YCripe Michael L · San Luis Obispo, CAN5343BSkydive Moab LLC · Moab, UTFirst renewal noticeN5343DHusnik Brad M · Forest Lake, MNN5345UMidwest Avtech Inc · South Barrington, ILN5346BSale Reported · Jasper, TXSale reportedN5346NMustang Manufacturing Inc · Carson City, NVN5348EDexter Brady R · Chambers, NEN5348UC3 Shadow LLC · Columbus, OHN5348YWheeler Robert T · Silt, CON534FLeiser Harry W · Rome, PAN534PCSutton Brad · Vallecito, CAN5350SSilver Tree LLC · Southern Pines, NCN5351DSplan David L · Mccall, IDN5352NAhrens Douglas T · Los Altos, CAN5353DMcmahan Charles B · Gakona, AKN5354BN5354b LLC · Manhattan, MTN5354SArcturus Bootes LLC · Wilmington, DEN5355DFischer Alfred M DBA · Genoa City, WI
Back to AD 84-10-01 R1