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.
N9310NApproach Partners LLC · Franklinton, NCN9310WGb Aviation LLC · Alpine, CAN93116Wichita Area Technical College · Wichita, KSN9311DRegistration Pending · Knoxville, TNRegistration pendingN9311JSentelle Amanda L · Frederick, MDN9311MShamshir LLC · Lake Havasu City, AZN9311NAmendt Joseph J III · Plymouth, MNN9311VRegistration Pending · Queen Creek, AZRegistration pendingN93124Pavco Inc · Gig Harbor, WAN93127Dunn W Eric · Lake Wylie, SCN9312DMcdonald Steve W · Lino Lakes, MNN9312MSteinman Marc J · Frankfort, ILN9313BAirplanes And Helicopters Of Oregon LLC · Sisters, ORN9313CWright Terrence Richard · Tiffin, OHN9313DSteneker Siardus L · Vashon, WAN9313HFlying Ten Flying Club · Phoenix, AZN9313JLockhart Michael B · Redlands, CAN9313KStauffer Donald R Jr · Tracy, CAN9313LKlutz Stoner W · Bristol, TNN9313M9313 Mike Inc · New Smyrna Beach, FLN9313WDjb Aviation LLC · Pompano Beach, FLN93142Geoffrion Curt J · Kenai, AKN9314DCallahan Ashton G · Homer, AKN9314EHall Kenneth B · Merritt Island, FLN9314HAzevedo Bradley J · San Francisco, CAN9314LEastern Stearman Inc Trustee · Leesburg, VAN9314PCapoferri Robert · Hammonton, NJN9314TGriffith Stephen P · Merritt Island, FLN93154H & H Aviation Enterprises LLC · Fairfield, OHN9315DZoviv Michael · Hollywood, FLN9315ESmith Mark S · Cornville, AZN9315JKruthoff Bret · Charles City, IAN9315LWilliams Matt D · Xenia, OHN9315NDiir County Flying Inc · Sturgeon Bay, WIN9315RChase Steven J · Aubrey, TXN9315SBradford Alvin L · Northville, MIN9315VGroff Joseph J · Colfax, CAN93166Kelly William W · Springfield, ORN9316JStennis Aviation Group LLC · Mandeville, LAN9316MSale Reported · Kalispell, MTSale reportedN9316VBorghi Robert J · Leonia, NJN9316WPrettyman James M · Sykesville, MDN9317RLloyd William E Jr · Clinton, TNN9317VSpaghetti Aviation LLC · Derby, KSN9318BAnderson Daniel R · Venus, TXN9318CTarakji Mohamad Hani A · Van Nuys, CAN9318JJohnson Matt · Eugene, ORN9318TGuerra Eduardo · Polk City, FLN93196Registration Pending · Lafayette, LARegistration pendingN9319DCloud Buster LLC · Bloomfield, IA
Back to AD 81-18-04 R2