AD 81-18-04 R2
Registered aircraft · 81,733
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-18-04-R2')
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-18-04-R2')
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-18-04-R2') 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-18-04-R2') 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.
N9597ZHanson James A · Bandon, ORN9598AKerr Jerry T · Mount Vernon, WAN9598BIpsen Michael · Kenosha, WIN9598DDurden William L · Tallahassee, FLN9598HImsar LLC · Springville, UTN9598JMardis Andrew · Pelzer, SCN9598MBergland John Edward · Santa Monica, CAN9598UJackler Leon J · Silver Spring, MDN9598ZDel Valle Enterprises Inc · Sandpoint, IDN95993Delta State University · Cleveland, MSN95995Hagele Aviation LLC · Hillsboro, ORN9599JOrban Kenneth D · Tellico Plains, TNN9599KRed Wing Soaring Association · Osceola, WIN9599WNelson Scott G · Lakota, NDN9599ZBorn John G · Jupiter, FLN959AANorth Wheeler O · Carlsbad, CAN959AGGrant Altin C · Tahlequah, OKN959BWRegistered aircraftN959CVaero Inc · Vinton, VAN959CFCarbonflight LLC · Hermosa Beach, CAN959CPCivil Air Patrol · Maxwell Afb, ALN959DBSigma Pharmaceuticals LLC · Monticello, IAN959DSDelta State University · Cleveland, MSN959ERs Specialties LLC · Anchorage, AKN959EDDoering Eric A · Litchfield, MNN959GAtp Aircraft 9 LLC · Wilmington, DEN959GTR&R Aero Services LLC · Eden Prairie, MNN959HCNorthwest Wings LLC · Hillsboro, ORN959JATriple Eagle Aviation LLC · Cambridge, VTN959JSSharkey James T · Bennington, VTN959PDMilligan Thomas A · Dana, INN959RDDoering Ray A · Devils Tower, WYN959RMLargent Richard B · Southport, NCN959TELawless John M Jr · Tucson, AZN959UAUniversity Of Alaska Anchorage · Anchorage, AKN959YBoard Of Trustees Of Southern Illinois University · Carbondale, ILN95AACoolidge Marvin L · Newberg, ORN95AFNeville William J III · Marianna, FLN95AHBrown Hunter · Sulphur Rock, ARN95APWingnut Enterprises Inc · Sarasota, FLN95AWScotts Air LLC · Prescott, AZN95BEAmundson David Owen · Sioux Falls, SDN95BJJames William M Jr · Cresson, TXN95BNMcphillips Flying Service Inc · Charlevoix, MIN95BPPeraton Services LLC · Bozeman, MTN95BRChickasha Wings Inc · Chickasha, OKN95BTCampbell Allen B · Meggett, SCN95CHJones Cecil W · Fort Walton Beach, FLN95CJSimmons Marshall · San Antonio, TXN95CPGates Thomas S · Moyock, NC
Back to AD 81-18-04 R2