AD 81-06-05 R1
Registered aircraft · 149
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:81-06-05-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:81-06-05-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:81-06-05-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:81-06-05-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.
N5007FPatriot Aviation Inc · Greenville, DENon-citizen corporation, flight hours not reportedN5013GHmc Lift LLC · Wilmington, DEN5017GHelimontana.Com LLC · Livingston, MTN505RLOrgis Bj · Hallettsville, TXN516LERotor Republic LLC · Orlando, FLN52AEAir Evac Ems Inc · O Fallon, MON52PLParatus Air DBA · Auburn, INN53AEAir Evac Ems Inc · O Fallon, MON54AEAir Evac Ems Inc · O Fallon, MON54NYWisk Aero LLC · Mountain View, CAN566AFRickards Aviation Group LLC · Dagsboro, DEN570JHHarnden Aviation Group LLC · Harrisburg, PAN570LEHhl LLC · Denver, CON570RLJasons Helicopter Services · New Prague, MNN571CJRotorpro LLC · Sevierville, TNN57441Jbi South Leasing LLC · Pembroke, NHN5745YMonarch Enterprises Inc · Kirkland, WAN57491Monarch Enterprises Inc · Kirkland, WAN5751MTrinkle Aviation LLC · Kingburg, CAN595AEAir Evac Ems Inc · O Fallon, MON59AEAir Evac Ems Inc · O Fallon, MON59CHAir Center Helicopters Inc · Burleson, TXN601GMNorth Wind Aviation LLC · Cottage Grove, ORN619Air Flite Inc · Shawnee, OKN63AEAir Evac Ems Inc · O Fallon, MON64FCZma LLC · North Little Rock, ARN660HAHelicopter Applicators Inc · Gettysburg, PAN6651HR & R Conner Aviation LLC · Conner, MTN66RRRiggs Rock Alan · Lake Mary, FLN68AEAir Evac Ems Inc · O Fallon, MON720BGentem Inc Trustee · Wilmington, DEN749FFHunt-Lo Farms LLC · Chesterland, OHN76DCAdvanced Trucking LLC · Kalispell, MTN777EMAlaskan Wings LLC · Anchorage, AKN7978KMowata Farms LLC · Mamou, LAN79AEAvid Aviation Group Inc · Jupiter, FLN79LRHeger Scott · Scappoose, ORN79TVBank Of Utah Trustee · Salt Lake City, UTN7DQMinnesota Helicopters Inc · Blaine, MNN801CLAv8-Orr Helicopter Services Inc · Hamilton, MTN828WPBas Part Sales LLC · Greeley, CON83AEAir Evac Ems Inc · O Fallon, MON85AWScotts Helicopter Service · Le Sueur, MNN89AEAir Evac Ems Inc · O Fallon, MON902EHNorth Wind Aviation LLC · Chelan, WAN903BAMarks Lloyd L · Lafayette, LAN96AEAir Evac Ems Inc · O Fallon, MON979NFresh Air LLC · Camarillo, CAN9993CTemplar Helicopters LLC · Glendale, AZ
Back to AD 81-06-05 R1