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.
N50KSedghi Reza · Macon, GAN50LGUpham Chester R III · Mineral Wells, TXN510GRJohnson Lynn L · Grafton, NDN510LJJohnson Lynn L · Grafton, NDN511AMRegistered aircraftN512HKGeneral Atomics Aeronautical Systems Inc · Poway, CAN513DMWeissenburger Aviation Inc · Wilmington, DEN515AMAllen Myland Inc · Media, PAN515SGGeneral Atomics Aeronautical Systems Inc · Poway, CAN517NCConquest 441-0355 Inc Trustee · Wilmington, DEN51DMJersey Ordnance Inc · Westampton, NJN529KCAerial Crop Care Co · Hebron, NDN52MATeem Properties LLC · The Villages, FLN52PYJk Aviation LLC · Carson City, NVN53016Earles Spray Service Inc · Breckenridge, MIFirst renewal noticeN531CBSpectre Aviation LLC · Dover, DEN5411JTdm Aviation LLC · Huntsville, ALN5441MBas Part Sales LLC · Greeley, CON548UPUas Transervices Inc · Boca Raton, FLN549WBPm Leasing Inc · Perris, CAN54PCAxel Neil Jeffery · Portland, ORN54USSilver Eagle Express LLC · Orange, CAN553AMUnderwood Chris · Beverly Hills, FLN555TNGeneral Atomics Aeronautical Systems Inc · Poway, CAN555VEPrincess Aviation LLC · Fowler, CAN558TJMorgans Flying Service LLC · Morse, LAN559CGOrtiz Luis Emerito Nieves · Ciudad De PanamaNon-citizen corporation, flight hours not reportedN5611XMarshall Jerry D · Hachita, NMN561UPUas Transervices Inc · Boca Raton, FLN563TRKolob Canyons Air Services Inc · Wilmington, DEN564TRCareer Aviation Co · Wilmington, DEN573GUas Transervices Inc · Boca Raton, FLN57VEN64fd LLC · Wilmington, DEN580ERBlue Ocean Aerospace LLC · Fort Collins, CON580SBott Radio Network Inc · Gravois Mills, MON586DVFlying A Flight Service LLC · Safford, AZN5878KClearwater Airco LLC · Anchorage, AKN5926KGulfstream Aerospace Corp · Savannah, GAN599ASTtc Aircraft Leasing Inc · Celina, TXN59KSOconnell Meares Investments Ltd · Tampa, FLN5LCCalm Air Aviation Inc · Nunica, MIN600JEDeja Mu LLC · Rye, NYN600PSPlane Services LLC · Twin Falls, IDN601SDNorthern Jet Sales LLC · Port Saint Lucie, FLN604ARConstruction Helicopters LLC · Howell, MIN604ECEast Coast Flight Services Inc · Easton, MDN6096YKlein Flying Service Inc · Lawrenceville, ILN60TEAerostar Holdings LLC · Kalispell, MTN611BABemidji Aviation Services Inc · Bemidji, MNN611RHMcneely Charter Service Inc · West Memphis, AR
Back to AD 2012-02-06