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.
N6MHPaquette Daniel J · Belleville, MIFirst renewal noticeN6MXHale Mitchell D · Palmer, AKN6NGAvalle Carlos A · Livermore, CAN6NHStephens Timothy D · Springfield, MON6NSWestern Flying Club Inc · Burlington, NCN6PFSoplanda Matthew J · Willow, AKN6PMGoode Max T · Mariposa, CAFirst renewal noticeN6PTStrange Jim · Tyler, TXN6PUMoreno Juan T · Stockbridge, GAN6QKRobb Jeffery A · Hebron, OHN6QUHoward Timothy D · Port Orange, FLN6RRegistered aircraftN6RBBush Robert · Landisville, PAN6RESouthwest Lakes Experience LLC · Sawyer, MIN6RXG&M Aviation LLC · Kokomo, INN6SBFranklin Gary · Willow Beach, AZN6SGCedar Ridge Aviation LLC · Knox City, TXN6SKKilpatrick L Shawn · Hartwell, GAN6SYKirkpatrick Andrew T · Corpus Christi, TXN6TAGarrard Walter E · Elbert, CON6TDCapouch Michael J · Medaryville, INN6TVTravelaire Service Inc · Wilmington, DEN6UKN6uk LLC · Goshen, INN6UULoerzel James E · Arlington Heights, ILN6VDEllison Jeremy · Dayton, NVN6VKQuagmire LLC · Hurricane, UTN6WChase Roy M · Limington, MEN6WADue North Aviation LLC · League City, TXN6WEHigh Flight Aviation LLC · Harwinton, CTN6WNDart Gregory G · Mayville, NYN6WRCueva Arturo A · Los Angeles, CAN6XAFlying Farmers LLC · Dalhart, TXN6XCNorthstar Aerospray Inc · Clara City, MNN6XLCrowe Donald L · Mcallen, TXN6XQAccuracy 1st · Canadian, TXN6YEExperimental Aircraft Association Inc · Oshkosh, WIN6YGArcher Project Management LLC · Forney, TXN6YLHolman Leasing LLC · Anchorage, AKN6YPAircraft Guaranty Corp Trustee · Oklahoma City, OKN6YQBeek Dudley E · Miami, FLN6YSHawk Aircraft Sales & Leasing LLC · Sterling Heights, MIN6YTCassinelli Steven W · Oceanside, ORN6YVZadrozny Pedro A · Wellington, FLN6ZHarris Hayden H · Chelsea, MIN6ZGTta Logistics LLC · Christiansted, VIN6ZHPetranek Diana C · Albion, NYN6ZPAmerican Patrols Inc · Midland, TXN6ZRBreed Paul T · Solana Beach, CAN6ZTLewis Eddy L · Cortez, CON700Dailey Jeffrey D · Weirton, WV
Back to AD 81-18-04 R2