AD 96-18-13
Registered aircraft · 1,110
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:96-18-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-18-13')
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:96-18-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-18-13') 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.
N664MMAquarius Aircraft Leasing LLC · Nashville, TNN666KLWj Of Delaware Inc · Fort Lauderdale, FLN667HFBd Plane Inc · Chicago, ILN667WJConnell Blue LLC · Berkeley Heights, NJN669MDDmc Aviation LLC · Scottsdale, AZN669RARoyal Air Freight Inc · Waterford, MIN66GESunshine Aero Industries Inc · Crestview, FLN66VAFranco Plastering Inc · Naples, FLN66ZBCharter Equipment Leasing LLC · Bellevue, WAN670JDAmber Services Inc · Chicago, ILN671MMKmwflight LLC · Wilmington, DEN671RRAircraft Fidelity Corp Trustee · Dover, DEN673HBSigma Equity LLC · San Francisco, CAN676GHNoll Air LLC · Orlando, FLN67ELWard Ohara Companies LLC · Kansas City, MON67FSBank Of Utah Trustee · Salt Lake City, UTN67PWNunya LLC · Irvine, CAN680JSBank Of Utah Trustee · Salt Lake City, UTN680KTSay Tony S · Oklahoma City, OKN682DN682d LLC · Wilmington, DEN686BCDodson International Parts Inc · Rantoul, KSN689WTotal Prf LLC · Lewes, DEN68CBCracker Barrel Old Country Store Inc · Lebanon, TNN68LMAmerica Aviation LLC · Yuma, AZN696JMFalcon Aviation Services LLC · Dallas, TXN699BGWord Of Life Christian Center Inc · Darrow, LAFirst renewal noticeN69BSDspa LLC · Baton Rouge, LAN69VHKolob Canyons Air Services Inc · Wilmington, DEN6FJFlying Farmer LLC · Wilmington, DEN6NRSdi Aviation LLC · Rhinelander, WIN700LWAircraft Resource Center Inc · Lakeville, MNN700MHMotor City Aeronautics LLC · Okemos, MIN700PGAviation Xx LLC · Wilmington, DEN700RRDaxen Logistic LLC · Chino, CAN700SRMd Jet Aviation Services Inc · Wilmington, DEN702SMTeam Aero LLC · Olathe, KSN703DJCommercial National Bank Of Brady · Brady, TXN704JMCnhi LLC · Montgomery, ALN707JQPinnacle Aviation Group LLC · Wilmington, DEN709LPPilgrim Air LLC · Van Nuys, CAN70AYSmi Air LLC · Wilmington, DEN70DTJet Set Aviation LLC · Memphis, TNN70LFWind Turbine And Energy Cables Corp · Hasbrouck Heights, NJN70PLFalcon 33 LLC · Las Vegas, NVN70SKDylan Dublin Air LLC · Hobe Sound, FLN70TTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN710HRAsf Aviation LLC · Cortlandt Manor, NYN710VPTx N710vp LLC · Austin, TXN711ECSemper Paratus Td I LLC · Allentown, PAN711FGJackpot Jet LLC · Sugar Land, TX
Back to AD 96-18-13