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.
N5536JHanna Patricia A · Davis Junction, ILN5536PGryhon Designs · Camden, SCN5536QWokini Air LLC · Tarpon Springs, FLN5536UPittman Discover Flight LLC · Oshkosh, WIN5536WSchilke Kenneth · Imperial, NEN55372Mccarroll Daniel C · Saint Augustine, FLN55374American Patrols Inc · Midland, TXN55378Iacobacci Timothy · Fairborn, OHN5537ARobinson Albert B · Byhalia, MSN5537HLine Michael · University Park, MDN5537KSales First LLC · Jasper, GAN5537MWiglesworth David G · Lenexa, KSN5537PField Gerard · Middleboro, MAN5537RBalady Nabih · Santa Clarita, CAN5537SMcpeak Alan W · Colorado Springs, CON55380Clark Joseph David · Kilgore, TXN55383Winkelman James R · Zionsville, INN55386Redlands Flying Club · Redlands, CAN5538ARado Robert L · Petersburg, MIN5538KHilowitz Andrew J · Anchorage, AKN5538QDurkee Brenton J · Brooklyn, NYN5538UAircraft Sales LLC · Caledonia, MIN5538ZBradburn William P · Pearl River, LAN55390Davis Hunter · Winters, TXN55392Fast Aircraft Aerowork Corp · Fort Lauderdale, FLNon-citizen corporation, flight hours not reportedN55397Stephens Ryan L · Gardner, ILN55398Three Wire LLC · Portland, ORN5539ASchneider Benjamin J · Wheeling, WVN5539FAeronautical Technical Service Inc · Collierville, TNN5539JCarr Paul · Ottumwa, IAN5539QJostad Leo D · Bottineau, NDN5539TPattison Aero Inc · Henderson, NVN5539UDickey Blaine K · Marion, ARN553APAviation Paradise LLC · Homestead, FLN553BBJpm Flying Service LLC · Marine, ILN553BCCarlson Robert A · Red Wing, MNN553BDBooker Daniel R · Newaygo, MIN553FLWalters Rande L Sr · Lock Haven, PAN553HBrantley Hugh L · Hazlehurst, GAN553KMRieder Kenneth J · Cincinnati, OHN553MBBickling Melvin T · Johnstown, CON553PCSaint Louis University · St Louis, MON553PGAnderson Adam Z · Bay City, MIN553PUSkyborne Airline Academy Inc · Vero Beach, FLN553RARich Aviation Services LLC · Fort Worth, TXN553RVLittmann Daniel M · Broken Arrow, OKN553SWillhoite Steven B · Louisburg, KSN553SCSpartan Education LLC · Tulsa, OKN553SFSmith Nancy R · Duluth, MNN553TPOakland Flyers LLC · Oakland, CA
Back to AD 81-18-04 R2