AD 2002-01-09
Registered aircraft · 439
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-01-09')
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-01-09')
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-01-09') 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-01-09') 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.
N71TPNortheast Montana Stat Air Ambulance Cooperative · Glasgow, MTN723KPKalinin Partners LLC · Juneau, AKN724HFAir Methods LLC · Greenwood Village, CON724KPKalinin Partners LLC · Juneau, AKN725KPKalinin Partners LLC · Juneau, AKN726KPKalinin Partners LLC · Juneau, AKN728MGKnot Crazy Horse LLC · Thonotosassa, FLN72AZBank Of Utah Trustee · Salt Lake City, UTN732SBAero Shares LLC · Excelsior, MNN755EMSea Star Inc · Wetumpka, ALN766DLSky West Aviation Inc Trustee · Albuquerque, NMN76XCHangar C-403 LLC · Walnut Creek, CAN770FLTailwinds Aviation LLC · Wilmington, DEN771WBAir Bus LLC · Dickinson, NDN774DKOrr Franklin M Jr Trustee · Stanford, CAN776JTBoutique Air Inc · Dallas, TXN77ZAAngel Lou Aviation LLC · Gilford, NHN77ZEPmc Distribution Inc · Keswick, VAN781DLRice Flying LLC · Poplar Bluff, MON78PGLance Toland Ltd · Wilmington, DEN795MKSouthern Palms Leasing LLC · Sarasota, FLN798WCLonely Butte Management LLC · St George, UTN79CSFord Gt Holdings LLC · Fort Dodge, IAN7YRBoutique Air Inc · Dallas, TXN7ZTZia Air LLC · Redwood City, CAN802HSSecurity Holdings LLC · Richmond, VAN807JHClark Joseph · Seattle, WAN810VJVee Jay Equipment (De) LLC · Clarkston, MIN811VMGuardian Flight LLC · Lewisville, TXN812PAPriority Air Charter LLC · Kidron, OHN814PAPriority Air Charter LLC · Kidron, OHN816BPAls Aviation LLC · Westlake Village, CAN817WAWarner Alan/N-Leasing LLC · Fort Worth, TXN818RAWanderlust Air LLC · Fort Lauderdale, FLN828PCSbma Services LLC · Mcclellan, CAN828RXN828rx Inc Trustee · Wilmington, DEN832BHVahalda LLC · Bend, ORN8421ETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN84GEHighwings LLC · Fargo, NDN851RMLas Madronas Aviation LLC · Incline Village, NVN852ALMetro Aviation Inc · Shreveport, LAN853ALMetro Aviation Inc · Shreveport, LAN854ALAir Methods LLC · Greenwood Village, CON861PPIrlbeckbruch Plane LLC · York, NEN866KMMac Aviation LLC · Fargo, NDN870A & S Aviation LLC · Chesterfield, MON870CBRaci Management Company Inc · Ogden, UTN875RJUS Air Force Special Operations Command/A5km · Hurlburt Field, FLN87CBClayton Boyd Agricultural Equipment LLC · Valley View, TXN888GWSouthland Sod Farms Operations Inc · Oxnard, CA
Back to AD 2002-01-09