AD 2012-26-15
Registered aircraft · 5,558
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-26-15')
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-26-15')
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-26-15') 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-26-15') 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.
N126DNDelta Air Lines Inc · Atlanta, GAN126EBElainebrown LLC · Anchorage, AKN126HRSeminole Tribe Of Florida · Hollywood, FLN126LWTailwinds LLC · Houston, TXN126TSLife Flight Network LLC · Aurora, ORN126UWAmerican Airlines Inc · Forth Worth, TXN127AABank Of Utah Trustee · Salt Lake City, UTN127CRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN127DNDelta Air Lines Inc · Atlanta, GAN127RRPhiladelphia Church Of God Inc · Edmond, OKN127TWTw Leasing LLC · Oxford, CTN127UWAmerican Airlines Inc · Fort Worth, TXN1281RAlliance Air Parts Acquisitions Corp DBA · Oklahoma City, OKN128ANBank Of Utah Trustee · Salt Lake City, UTN128DNDelta Air Lines Inc · Atlanta, GAN128TSUmb Bank Na Trustee · Salt Lake City, UTN128UWAmerican Airlines Inc · Fort Worth, TXN129AABank Of Utah Trustee · Salt Lake City, UTN129DNDelta Air Lines Inc · Atlanta, GAN129PKDashiell Corp · Houston, TXN12AMTexas A&M University System · College Station, TXN12ARMermerus LLC · Branford, CTN12DHClear Skies LLC · Lafayette, LAN12JKAstec Industries Inc · Chattanooga, TNN12JSJs Aircraft Leasing III LLC · Aventura, FLN12NFNiemann Aviation LLC · Quincy, ILN12NVAir Ally LLC · Chisago City, MNN12QSCulligan International Co · Oklahoma City, OKN12VQDtm Aviation LLC · Statesboro, GAN12XFlying Goose LLC · Kennesaw, GAN12XNJdr Aircraft Company LLC · Tampa, FLN130ANBank Of Utah Trustee · Salt Lake City, UTN130WEWells Enterprises Inc · Le Mars, IAN131AFManufacturers And Traders Trust Co · Portsmouth, NHN131EPWingspan LLC · Holland, MIN131JXCbr Aviation LLC · Delaware, OHN131LGCharter Express Inc · Little Rock, ARN131NNBank Of Utah Trustee · Salt Lake City, UTN1321AAndromeda Leasing I LLC · Purchase, NYN132ANBank Of Utah Trustee · Salt Lake City, UTN132ASFlight Level Services LLC · Danville, KYN132NFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN132TPNational Eagle Aviation LLC · Grand Prairie, TXN133ANBank Of Utah Trustee · Salt Lake City, UTN133PEEpps Air Service LLC · Atlanta, GAN133RCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN133VSVrs Holdings LLC · Medina, OHN134ANBank Of Utah Trustee · Salt Lake City, UTN134FMPeno Bottom Aircraft LLC · San Luis Obispo, CAN134PFPeco Foods Inc · Tuscaloosa, AL
Back to AD 2012-26-15