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.
N892BVGd Aviation Inc · Belleair, FLN892CPCivil Air Patrol · Maxwell Afb, ALN892DLBd Aviation LLC · Sauget, ILN892EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN892NDUniversity Of North Dakota · Grand Forks, NDN892PTTims Duane R · Hemet, CAN892SGCraik Evelyn June · Las Vegas, NVN893012265 LLC · Mercer Island, WAN8930DBeverly Lester E · Shepherd, TXN8930JMccracken Blake R · Lake Havasu City, AZN8930MCuratola Bruce J · League City, TXN8930WMaurer Mark · Alamogordo, NMN89310Kuyl Marinus D · Forest Grove, ORN89312Hillsboro Aero Academy LLC · Hillsboro, ORN8931VAeroventures 8 LLC · Mt Carmel, TNN8932DRegistration Pending · Caldwell, IDRegistration pendingN8932MOlivieri Michael R · Wasilla, AKN8932VEverett William M · Tuscumbia, ALN8932YStrohmeyer Gregory C · Wasilla, AKN89333Chapel Hill Flying Club Inc DBA · Sanford, NCN89337Davis Andrea E · Lake Oswego, ORN8933DGrandy Leland P · Rock Springs, WYN8933JQuilling John R · Cannon Falls, MNN8933LDuncan Aviation Inc · Lincoln, NEN8933RThrall Gregory D · Seward, AKN8933WFlight Time LLC · Portland, ORN8934CHandel Patrick A · Wautoma, WIN8934PNermernuh LLC · Chester, CTN8934VUniversal Aviators Academy Inc · El Monte, CAN8934WNelson Cy D · Decorah, IAN8934YFuller John M · Minden, NVN89358Redstone Arsenal Flying Activity · Redstone Arsenal, ALN89359Mccartney Robert · Mountain View, CAN8935WJudd Ellen K · Burley, IDN8936JCloud Niners Inc · Brownsburg, INN89372Rodriguez Devin · Arlington, TXN89377Bishops' Ltd · Virginia Beach, VAN8937DBrunner Steve W · Mission Viejo, CAN8937LHood River Soaring · Hood River, ORN8937RBeckett David · Wasilla, AKN8937VCowden Steven B · Bellingham, WAN8937WArmstrong Wanliss E · Jal, NMN8938FSouthern Cross Aviation Inc · Wilmington, DEN8938JMeier Daniel J · Greenwood, INN8938YUniversity Of Alaska Anchorage · Anchorage, AKN89390Nevill Jordan J · Ukiah, CAN89392Story John D · Harrah, OKN8939CRegistration Pending · Lakota, NDRegistration pendingN8939JEstis Jonathan D · Walden, NYN8939LWestern Carolina Ag Air Inc · Catawba, NC
Back to AD 81-18-04 R2