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.
N69125Pine Hill Holdings LLC · Richmond, VAN6912JHammond Brian M · Gresham, ORN6912PAnzaldua Johnny J · Midland, TXFirst renewal noticeN6912WTop Flight Aviation Snh LLC · Savannah, TNN6913Cooper Steven J · Redwood City, CAN6913ANorthwoods Air LLC · Orono, MEN6913BKeyt Jeffrey D · New Providence, NJN6913JFlight Time LLC · Conover, NCN6913KMedcroft Sean M · Edmonds, WAN6913NJennings William A · North Little Rock, ARN6913RAirplane And Drone Flight Instruction LLC · Orlando, FLN6913SRural Development Corp 1 · Steamboat, CON6913UShaw Brian D · Meadville, PAN6913WAden James D · Gothenburg, NEN69149Joyner Carol M · Claremont, CAN6914AFlyn 6914 Alpha LLC · Oak Island, NCN6914BLark Bradley J · Enoch, UTN6914JKreppel Frederick W · Wayne, PAN6914ULiskey John W · Kelseyville, CAN6914VDuke Terri D · Oakwood, GAN6914WPearson Timothy M · Waterville, OHN69156Lehman Alexander D · Sanford, NCN6915H2gbs LLC · Wilder, IDN6915NBaker Stewart D · Severna Park, MDN6915QWilson Kenneth G · Peoria, AZN6915TSpier Samuel · Carson City, NVN6915VReindollar William Paul Jr · Derwood, MDN6915WOso Air LLC · Missoula, MTN69165Locaero Services Inc Trustee · Wilmington, DEN6916HFms Air LLC · Leesville, LAN6916KBrown Daniel A · Gettysburg, PAN6916NGray Wesley K · Sandia, TXN6916QShawn James R · Pattison, TXN69173Brs Leasing Inc · Wilmington, DEN6917APiper Aircraft Inc · Vero Beach, FLN6917DOlds Forge Flyers Inc · Lansing, MIN6917GMarvell Aviation LLC · Marvell, ARN6917NBonak Steven · Punta Gorda, FLN6917VCamper Daniel P II · Port Angeles, WAN6917WCloutier Michael C · Waddell, AZN69187Green Airports Development Corp · Kemah, TXN69189Lehman David G · Kent, WAN6918DTucker Christopher W · Johnstown, CON6918HWright Flight Inc · Tucson, AZN6918NBas Part Sales LLC · Greeley, CON6918WTopping Warren J · Sagaponack, NYN6919BPolyclinics.Net LLC · Hixson, TNN6919HTimmester Terry W · Little River, SCN6919JFlying Is Fun LLC · Atlanta, GAN6919MWest Byron Chad · Blue Grass, IA
Back to AD 81-18-04 R2