AD 2002-13-07
Registered aircraft · 824
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-13-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-13-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-13-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-13-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.
N303CLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN303TFNtc Aviation LLC · Greenwich, CTN304KSonic Automotive Inc · Charlotte, NCN306BHSdy Leasing LLC · Waterford, MIN307MDN307md LLC · Barrington, RIN30HQLearjet Inc · Wichita, KSN30TEV1vr LLC · Wilmington, DEN311KBJet Plaid LLC · Nashville, TNN312SHRegistered aircraftN313JLJnl Equipment Leasing LLC · Camden, DEN313RHRedwood Holdings LLC · Hanover, MDN313STIota Aviation LLC · Bloomfield Hills, MIN313WATvpx Trust Co LLC Trustee · North Salt Lake, UTN315REGrey Goose LLC · Pleasant Prairie, WIN316GBWellsprings Aviation LLC · Winston Salem, NCN317DTN42nh LLC · Oklahoma City, OKN317MNext Level Marine LLC · Mount Pleasant, TXN317MLMds Falcon LLC · Kittanning, PAN320GWSky Wheeels LLC · Prince Frederick, MDN321AJM Hixson Aviation LLC · Denton, TXN321AKSnails Pace Aviation LLC · New York, NYN321APTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN321EJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN3221BAurum Aviation LLC · Dallas, TXN322FJRegistered aircraftN323SEWard Ohara Companies LLC · Kansas City, MON324SLAp Aviation LLC · Troy, VAN325GMRegistration Pending · Salt Lake City, UTRegistration pendingN326EWLeco Corp · South Bend, INN3278Peregrine Falcon LLC Trustee · Boise, IDN327LXBoston Post Leasing LLC · Nashua, NHN327RXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN330KJet Sense Aviation Aircraft Holdings Corp · Lake Zurich, ILN331DCBlue Bird Adventures LLC · Springfield, TNN333KEFalconmitch Inc · Sulphur Springs, TXN333MXHappy Travels LLC · Whitefish, MTN338MJ A Real Estate Investments LLC · Fort Lauderdale, FLN33BGBoyd Gaming Corp · Las Vegas, NVN33VCSilver Lake Aviation LLC · Park City, UTN341APAircroft LLC · Sarasota, FLN34PCPace Falcon Leasing LLC · Plymouth, MIN34TJAbove The Rest Aircraft Services LLC · Midlothian, TXN34VHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN351MARugby Transit LLC · Boca Raton, FLN353BLBank Of Utah Trustee · Salt Lake City, UTN353WWBramac LLC · Denver, CON355MLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN356LGRegistered aircraftN358DATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN35CDCoastal Development Group LLC · Boca Grande, FLFirst renewal notice
Back to AD 2002-13-07