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.
N72219Sheets Mark W · Chugiak, AKN7221CPtg LLC · Princeton Junction, NJN7221JWilliams Maria M · Kernersville, NCN7221LKnutson Wayne R · Thompson, NDN7221PBuhrmeister Timothy J · Centereach, NYN7221QSleeping Giant Flying Club · Helena, MTN7222CMcshane Trent · Wasilla, AKN7222JAviation Partners Llp · Bismarck, NDN7222QMohawk Flying Club Inc · Ada, MIN7223DTonelli James D R · Locust Grove, GAN7223FBrown Richard G · Irvine, CAN7223KDowning Michael P · Yelm, WAN7223QBuiqui Aerospace Corp · Kissimmee, FLN7223RLively Charters Inc · Summerland Key, FLN7223WRajuan Oren · Sacramento, CAFirst renewal noticeN7224AClr Aviation LLC · Wilmington, DEN7224DBank Jeffrey J · Littleton, CON7224FBiviano Joseph J · Tehachapi, CAN7224KFlint Paul L · Anchorage, AKN7224MAffordable Construction Services Inc · Humboldt, TNN7224SCunningham Russell A · Zimmerman, MNN7224YDistel Harold M · Williamson, GAN7225GVance Wilbur H III · Hershey, PAN7225PSuperior Aviation LLC · Metairie, LAN7225VConnecticut Aircraft Sales LLC · Manchester, CTN7225WOshaughnessy Breandan · Allen, TXN7225YTwin Cam Holdings LLC · Union City, TNN7226DAdams Andrew V · Joplin, MON7226GHerlihy Douglas K II · Denville, NJN7226JChristffersen Robert H · Tacoma, WAN7226WStuart Ryan C · Snowflake, AZN7226YGilbert Douglas A · Weston, FLN7227DRobinson Eric C · Palmer, AKN7227FStrange Keith · Lincoln, MEN7227GBeltz Richard D · Lehighton, PAN7227JRad Aviation LLC · Abbeville, ALN7227KOlathe Spray Service Inc · Olathe, CON7227QElite Air LLC · Tullahoma, TNN7227YClearview Aerial Solutions LLC · Rogersville, TNN72282Merriam Paul · East Greenwich, RIN7228DAmigo Helicopter Services LLC · Falfurrias, TXN7228GFasking Dan · Stanford, ILN7228JRedhanded LLC · Dover, DEN7228ZHart Samuel C Jr · Newberry, SCN7229DBuergel Sandra J · East Aurora, NYN7229JLivingston Corey · Myrtle Beach, SCN7229NMccracken Donald D · Keyport, WAN7229QSwitzer Frank Jr · Port Allegany, PAN7229VRiggin Flight Service Inc · Madison, SDN7229WRoll The Bones LLC · Kiln, MS
Back to AD 81-18-04 R2