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.
N7303ZSeminole Flying Soaring Inc · Clermont, FLN73040Goulding Brian K · Roswell, GAN73041Max Air Aviation LLC · Carrollton, GAN73043Six Ten Ventures LLC · Cedar Hill, TXN7304FReid Brian S · Merced, CAN7304GChapman David C · Summersville, WVN7304JAdk Flying Club Inc · Ballston Spa, NYN7304TGalaxy Aviation LLC · Nantucket, MAN7304YN3024d LLC · Reno, NVN73054Blue Wings LLC · Spokane, WAN7305JMallozzi Anthony M · Norwalk, CTN7305LHill Stephen C · Fort Collins, CON7305YRegistered aircraftN73063Oregon State Flying Club · Corvallis, ORN73068Christensen Gary D · Alliance, NEFirst renewal noticeN73069Eagle Sky Patrol Inc · Deadwood, SDN7306DJ S H Farms Inc · Hermiston, ORN7306EG & M Aircraft Inc · Wheat Ridge, CON7306FMeans James · Burleson, TXN7306KKutschera Thomas C · Youngsville, NYN7306X06x-Ray LLC · El Paso, TXN7307DKnight Todd A · Grimes, IAN7307FEllis Johnathan · Evansville, WYN7307JAlmonte Duran Arquimedes · Paterson, NJN7307XZimmer Chris P · Upham, NDN7308CChandler Air Service Inc · Chandler, AZN7308GOrlandi Properties LLC · Blairstown, NJN7308JMacdermaid Harry R · Kenai, AKFirst renewal noticeN7308KBradley Gary C · Orchard Park, NYN7308ZKnutson Wayne R · Tioga, NDN73091Rudder33 LLC · Grantham, NHN73093Yngsdal Dale A · Lino Lakes, MNN7309CKeefer Ralph E · Markle, INN7309KStanley Bryan D · Paso Robles, CAN7309PEvergreen Underground Water Conservation District · Pleasanton, TXN7309YGlaser William Burnett · New Smyrna Beach, FLN730AMeridian Aircraft LLC · Wilmington, DEN730ACHeimbach Paul A · Steamboat Springs, CON730BRHagan David W · Overgaard, AZN730CAChristiansen Aviation LLC · Wilmington, DEN730DGGeib Daniel R · Millersville, PAN730EREmbry-Riddle Aeronautical Univeristy Inc · Prescott, AZN730FPutnal Aviation LLC · Ambrose, GAN730FNNguyen David · Cedar City, UTN730HAHonaker Group LLC · Sellersburg, INN730JKMcgrath Sean P · Plano, TXN730KFZero Kilo Foxtrot LLC · Grand Junction, CON730KPPeterson Robert Kd · Edgewood, TXN730LBEarly Bird Aviation LLC · Rillito, AZN730LKBay Aero Ventures LLC · Port Clinton, OH
Back to AD 81-18-04 R2