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.
N757LKNuckolls Douglas W · Lancaster, CAN757LMYeary Clifton K · Quitaque, TXN757LNWings Over Texas Holdings LLC · Denton, TXN757LPPrice Thomas E · Ogden, UTFirst renewal noticeN757LXSt Louis Flight Training LLC · Cahokia, ILN757LYHillsboro Aero Academy LLC · Hillsboro, ORN757MGOhio Gypsum Floors LLC · Westerville, OHN757MK101 Flight LLC · Waterford, MIN757MLSchaffer Michael W · New Meadows, IDN757MMDsr-Cherokee 180 LLC · Dallas, TXN757MPAvcorp Holdings Inc · Jackson, MIN757MSAngel Aviation Inc · Peoria, AZN757MYStaley Grady R · Liberty, NCN757NGWeisman Craig A · Falls Of Rough, KYN757NJSpace Coast Aircraft Co · Merritt Island, FLN757NNCarton David M · Claremont, NHN757NQA&R Aero LLC · Sacramento, CAN757PKoerner Lukes Gene · Wisconsin Rapids, WIN757PDLeavitt Erin G · Lewiston, IDN757PMKaiser Gavin · Peachtree City, GAN757PPFields Joseph H · Placerville, CAN757PTPavlock Russell H · Tinley Park, ILN757PUAvs Aviation LLC · Williamsburg, VAN757QBHutchison William B · Canton, OKN757QHWings Over Texas Holdings LLC · Denton, TXN757QJWaters Thomas J · Hampton, GAN757QQKostelecky Scott J · Decatur, TXN757QTMoxley Equipment Co Inc · Council Grove, KSN757RLRudak Phillip Richard · Wethersfield, CTN757RNSky Aviation & Maintenance Inc · Wildomar, CAN757RPBoyne Valley Flyers Club Inc · Boyne Falls, MIN757RSRegistered aircraftN757RTEnright Darren R · Lakeville, MNN757RVJohnson Scott E · Land O Lakes, FLN757RZCox Derrell L · Pamplico, SCN757SCHicks Byron · Manchaca, TXN757SDYu Hermon Lemuel C · Mays Landing, NJN757SP4e Aviation LLC · Alpine, UTN757SQByrne Sarah Boltz · Dallas, TXN757STChester Charter Inc · Chester, CTN757SWSt Charles Flying Service Inc · Portage Des Sioux, MON757TMontgomerie Robert A · Oriental, NCN757TAHofmeister Laurence C · Punta Gorda, FLN757TDNew Horizon Aviation Inc · Warwick, RIN757THGoodrich Pilot Training Center LLC · Johnson City, NYN757TLSky Candy LLC · Scottsdale, AZN757TMMayeur Terri-Jo · Wasilla, AKN757TVTri County Rentals And Sales Inc · Lake City, FLN757TWHildebrand Russell W · Chandler, AZN757UGehret Barry · Sonoma, CA
Back to AD 81-18-04 R2