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.
N6004Weller Steven C · Hummelstown, PAN60046Lee John C · Marietta, OHN6004QSmith Aviation Inc · Wilmington, DEN6004WDorr Martin E · Strongsville, OHN60051Compass Rose Aviation LLC · Derby, KSN6005JTextron Aviation Inc · Wichita, KSN6005QBittle Gary D · Bald Knob, ARN6005SCompass Rose Aviation LLC · Derby, KSN6005UHaney William R · Pontotoc, MSN6005ZMarstall Nancy T · Asheville, NCN6006DLedda Francesco · Canton, TXN6006WGreen William A · Memphis, TNN6007CAdler Jeffrey S Trustee · Westminster, CON6007FMobley Barbara Alice · Kathleen, GAN6007HPolice Facility Design Group Pa · Kansas City, KSN6007QRegistration Pending · Tampa, FLRegistration pendingN6007TMinton Richard D · Longville, LAN6007USteele Tucker L · The Colony, TXFirst renewal noticeN6007WMoore Merritt · Mcarthur, CAN6007YAudubon Air Of Louisiana LLC · Bossier City, LAN6007ZSharkey John F III · Oswego, NYN60083Kocik William J Jr · Shepherdstown, WVN60086Echo Bravo LLC · Helena, MTN6008DChristopher D Bock · Fishers, INN6008HSwartz Selden H Jr · Jacksonville, ORN6008KShore Stephen · Longview, TXN6008LGawlik Leslie W · Reisterstown, MDN6008URasmussen John E · Seffner, FLN6008XMangum Gary W · Centreville, VAN60096Barto Jerrel · Kula, HIN60097Ratliff Frank O · Palestine, TXN6009ACampbell Bryan P · Naples, FLN6009DKirkendall James A · N Richland Hills, TXN6009MKd 172 Ventures I LLC · Bellevue, WAN6009POh Air LLC · Mentor, OHN6009QDelone Charles P · Sarasota, FLN6009VMaui Aviators LLC · Pukalani, HIFirst renewal noticeN6009WLowman Jeffrey L · Clarksburg, WVN600AMid Atlantic Air Museum · Reading, PAN600AABrauer Jason R · Winnebago, ILN600APToombs Todd J · Peyton, CON600AVMountain Top Aviation Inc · Ebensburg, PAN600BAJacks Express LLC · Wilmington, DEN600BHBeaupre Harry R · Fallon, NVN600CJPoly Plastics Inc · Owatonna, MNN600CWWinn Kathy J · Spring, TXN600DWDigital Production And Design LLC · San Mateo, CAN600EZMoore Glenn C · Elkhart Lake, WIN600FSHome Free Aviation LLC · New Port Richey, FLN600GGNlh Aviation LLC · College Station, TX
Back to AD 81-18-04 R2