AD 2012-02-06
Registered aircraft · 659
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:2012-02-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-02-06')
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:2012-02-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-02-06') 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.
N405VAInternational Bank Of Commerce · Laredo, TXN406VAInternational Bank Of Commerce · Laredo, TXN4089QBruces Flying Service Inc · Arlington, GAN4090MCorsair Turbines LLC · Georgetown, TXN4090WMauck Flying Service LLC · Hoxie, KSN409VAZeroavia Inc · Hollister, CAN40AMAisling Developments LLC DBA · Calhoun, GAN40KCAir 1st Aviation Companies Inc · Glendale, AZN4152XAero Spray Inc · Kingfisher, OKN419SCZeplane LLC · Miami, FLN41NVNorth Valley Air Ltd · St Thomas, VIN4206PHeritage Ag LLC · Lakeview, MIN4208SOmega Air Service LLC · Fredericksburg, OHN420LWCrazy Horse LLC · Princeton, WVN4217XEarls Spray Service Inc · Breckenridge, MIN421MAUas Transervices Inc · Boca Raton, FLN4223XAir Enterprises LLC · Dover, DEN422CABering Air Inc · Nome, AKN4239XMountain Air Spray Co · Craig, CON423DB2945l LLC · Terrell, TXN423KAKmr Aviation Services Inc · Lynchburg, VAN424CARyan Air Inc · Anchorage, AKN424MAUas Transervices Inc · Boca Raton, FLN425DFUsda Forest Service Fepp · Mcclellan, CAN425DTSun Fast Inc · Mansfield, TXN425MACbg LLC · Wilsonville, ORN426CASpitaker Leasing LLC · Colorado Springs, CON426DFUsda Forest Service Fepp · Mcclellan, CAN426MAUas Transervices Inc · Boca Raton, FLN428MAUas Transervices Inc · Boca Raton, FLN429HKGeneral Atomics - Aeronautical Systems Inc · Poway, CAN42AFWild Hare Enterprises LLC · Valparaiso, INN42AXTheia Aviation LLC · Philadelphia, PAN430MAGas/Wilson Inc · Traverse City, MIN430RRAce In The Sky LLC · San Antonio, TXN434CAHorizon Aire LLC · Colorado Springs, CON439DFUsda Forest Service Fepp · Mcclellan, CAN439RARyan Air Inc · Anchorage, AKN43GTDon Avion LLC · Cedar Park, TXN440ATT & M Aircraft LLC · Monticello, ILN440EHSurdex Corp · Chesterfield, MON441ABank Of Utah Trustee · Salt Lake City, UTN441ABPistol Aviation LLC · Anaconda, MTN441AQM & M Aircraft LLC · Mankato, MNN441BBMountain Sand Investment LLC · Wilmington, DEN441BKBek Consulting LLC · Dickinson, NDN441BLZero Zero LLC · Enterprise, UTN441CCNoem Troy · Grand Junction, CON441CJNv5 Geospatial Inc · Sheboygan Falls, WIN441CTAberdeen Flying Service · Aberdeen, SD
Back to AD 2012-02-06