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.
N68WYAviation Mentoring Program LLC · Phoenix, AZN68XLsk Aviation Corp · Wilmington, DEN6900Adams Paul T · Pompano Beach, FLN69007Jj Kramer Aviation LLC · Vero Beach, FLN69009Jwa Flight School LLC · Bolingbrook, ILN6900DMahoney Shane · Auburn, WAN6900HCp Aviation Inc · Santa Paula, CAN6900JCaruso Jerry W Jr · Kingsbury, NYN6900NBond William E · Elk River, MNN6900PMyer Charles G · Forest Lake, MNN6900TAircraft Guaranty Corp Trustee · Oklahoma City, OKN6900URegistered aircraftN6900WHall William Brent · Tulia, TXN6900ZIndependence Glider Club · Independence, ORN69011Sunrise Aviation Inc · Ormond Beach, FLN69012Chapel Hill Flying Club Incdba · Sanford, NCN69016Hillsboro Aero Academy LLC · Hillsboro, ORN69019Lange Walter · Plymouth, MAN6901ASpence Stephen L · Anchorage, AKN6901HRieser Steven E II · Baltimore, OHN6901NRagsdale James W · Geneva, FLN6901QCbus Flight LLC · Pickerington, OHN6901ULime Lounge LLC · Des Moines, IAN69023Gilbert Jeffrey R · Dahlonega, GAN6902DFerrell Alan B · Arlington, OHN6902NSherrill Charles H · Robert Lee, TXN69031Lewis Garry L · Livingston, LAN69036Long Robert D · Kinston, NCN6903BJones Gary L · Kerrville, TXN6903JGreen Valley Aerospace LLC · Lexington, VAN6903NRoland Jason R · Royse City, TXN6903PStack Gregory R · Aurora, CON6903QSullivan Lynford M · Hernando, MSN6903RFusion Marine Inc · Stuart, FLN6903UPray Aviation Inc · Augusta, KSN69042Poplar Grove Airmotive Inc · Poplar Grove, ILN69043Davidson Craig H · Heber City, UTN69045Eburg Aero LLC · Ellensburg, WAN69047Wings Over Texas Holdings LLC · Denton, TXN6904ALesser Antilles Corp Trustee · Wilmington, DEN6904DLucas Michael F · Germantown, OHN6904KHolcomb Garry M · Point, TXN6904NSchaffhauser Daniel L · Garland, TXN6904UMyers Ronnie L DBA · Appling, GAN69053Aerofeather Aviation Inc · Suffolk, VAN6905DEvans Theresa K · Alexandria, MNN6905HTang Flyer LLC · Wausau, WIN6905JDouble Delta Sierra LLC · Bristol, CTN6905NZero Five November Holding Inc · Kalispell, MTN6905PMampel Gregory J · New Port Richey, FL
Back to AD 81-18-04 R2