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.
N967MSMt San Antonio College · Walnut, CAN967ROpen Sky Aviation LLC · Salem, ORN967SAElizabeth City State University · Elizabeth City, NCN967SHSoco Aero Leasing LLC · Santa Rosa, CAN967WMLionheart Enterprise Co LLC · Chino Valley, AZN96808Hill William G Trustee · Laguna Niguel, CAN96809Folsom Realty Group Inc · Greenville, MEN9680CGregorski Thomas E · Kenly, NCN9680DGoundry George D · Sammamish, WAN9680JAltizer Joseph F · West Logan, WVN9680PB407 LLC · Seattle, WAN9680QAircraft Guaranty Corp Trustee · Oklahoma City, OKN9680WConrady Colt · Laguna Niguel, CAN9681Srividya Aviators LLC · North Brunswick, NJN9681DLynch Sean L · Brighton, ILN9681FSplashdown Aviation LLC · Dunedin, FLN9681HDavis Lester Jr · George West, TXN9681PHibbert Kim O · Anchorage, AKN9682HCloutblazer LLC · Sacramento, CAN9682JLenz Frank M · Boca Raton, FLN9682MMccormick Borrero Ramon A · Ponce, PRN9682NOhman Chris M · Tulsa, OKN9682PHutchison Don D · Wounded Knee, SDN9682SRoethlisberger John · Beaver Falls, PAN9682VBanks Michael R · Macon, MSN9682WCullen Clay T · Danbury, CTN9682ZHowell Jason D · Salem, ARN96836Visalia Flyers LLC · Visalia, CAN96839Eastern Shore Aviation · Onancock, VAN9683BTita Enterprises LLC · Apex, NCN9683DSmith James A · Lyle, WAN9683HCook Samuel Jordon · Thibodaux, LAN9683JDale Allyson K I · Clarkston, MIN9683MPourteau Patrick Steven · West Columbia, TXN9683PWarthog Flying Service Inc · Stuttgart, ARN9683QBering Capital LLC · Anchorage, AKN9683UNorris Tracy N · Channelview, TXN9683WHincy William P · Palmdale, CAN9684JBlackstone Aircraft LLC · Hartselle, ALN9684MMayes John · Carson City, NVN9684PNotti Jae A · Otter, MTN9684QOgden Laurence B · Weaverville, NCN9684SGt Aviation LLC · Kalispell, MTN9684WGousios Eleni E · Rocklin, CAN9685CCendejas Agustin · Chino, CAN9685DPadgett Matthew K · Star City, ARN9685ESwanson Michael J · Wayzata, MNN9685GAltitude Asset Management LLC · Waukesha, WIN9685HBoys Will Fly LLC · Mapleton, UTN9685PJones Victor E · Cordova, AK
Back to AD 81-18-04 R2