AD 2002-16-07
Registered aircraft · 985
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:2002-16-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-16-07')
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:2002-16-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-16-07') 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.
N286TAMfga LLC · Smyrna, TNN287DGGardner David C · Williston, SCN290JJThompson James W · Bronwood, GAN291FASafety Management Training LLC · Hamburg, NYN292CFWingsleasing LLC · Wichita, KSN294CMLag Drywall Inc · Hampton, GAN2979AVannuil Jerry E · Holland, MIN297RHanley Mark S · Bristol, MEN298BLAmbient Air Technologies LLC · Fort Collins, CON299TANorth Country Aero LLC · Hanover, NHN29FPCaribbean Amphibian LLC · Punta Gorda, FLN29STShewmaker Air LLC · Bentonville, ARN29WGClinton Peter C · Cheyenne, WYN300MJSnider Aaron Andrew · Hart, MIN302CAAviation Financial Corp · Torrance, CAN3035GMason Brooks Aviation LLC · Severn, MDN304PBMcgehee Aviation Services LLC · Zephyrhills, FLN304PPArrington Ray · Jackson, MIN304USBuiqui Aerospace Corp · Kissimmee, FLN304WSMaberry Buell G · Pierre, SDN30628Zollinger Rudolph A · Rittman, OHN307DNRegistration Pending · Scottsdale, AZRegistration pendingN30ALLink Alden · Milton, NYN311DZSawaf Darius · Dallas, TXN31311Mcclure Jared B · Claremore, OKN313CMTray Jason R · Juneau, WIN31408Adams John P · Rosebud, MON3143MSmile Machine LLC · Auburn, WAN3143SStafford Marlin C · Patterson, GAN314BJClayton Smith · Green River, WYFirst renewal noticeN31718Ohlrich Greg · Mount Dora, FLN3173PHalberg Bill R · Battle Ground, WAN31750Yeats Chris P · Collinsville, OKN31788Falcontrust Holdings LLC · Pinecrest, FLN317GWWings Over Texas Holdings LLC · Denton, TXN31EEJudd Tharon · Orem, UTN3200VKnight Brent · Moundridge, KSN321CAGarratt Carol Ann · Moriarty, NMN321HCLinda Vista Aviation Inc · West Palm Beach, FLN322PZUsibelli Joseph E · Fairbanks, AKN329PTPilot Training Center LLC · Miami, FLN330BLCentral Seaplanes LLC · Cleveland, OKN330VAN330va LLC · Plymouth, MIN33223Clayton Randall L · Mapleton, UTN333VTCanfield Dan · Ephrata, WAN334CTAngel LLC · Missoula, MTN334QHuitema Tom P · Portage, MIN3372Sky West Aviation Inc Trustee · Albuquerque, NMN337SELee Mark J · Arlington, WAN339PDWhiteley James N · Reno, NV
Back to AD 2002-16-07