AD 2012-10-13
Registered aircraft · 13,306
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-10-13')
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-10-13')
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-10-13') 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-10-13') 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.
N821PGreen Bandit Air LLC · Vinita, OKN821SRN821sr LLC · Rio Rancho, NMN821TRExcelsior Aviation Inc · Fresno, CAN821WMMaricorp Aviation LLC · Shell Knob, MON822Troutman Shaun L · Johnson, KSN8223QBas Part Sales LLC · Greeley, CON8228ZSquare Cube Flying Inc · San Diego, CAN822ASValiant Air Command Inc · Titusville, FLN822BLLabsf LLC · Ocala, FLN822CDMedphys Corporation · Largo, FLN822CPValant Ashley · Seattle, WAN822CWN822cw LLC · Englewood, CON822DDWhiskey Tango Folks LLC · Walnut Cove, NCN822DRFeng Zhi Peter · Flushing, NYN822GGBurton Aviation LLC · Neenah, WIN822GMDevault Bryan · The Woodlands, TXN822JJEcho 2112 LLC · Orlando, FLN822MBLx7 Air LLC · Newark, DEN822MCCirrus 822mc LLC · Wilmington, DEN822MSGo Blue Holdings LLC · Atlanta, GAN822RBristol Bay Aviation LLC · Scottsdale, AZN822RAAshworth Aviation LLC · Tampa, FLN822SCSawaf John N · Gray, TNN822SJMouse Air LLC · Indianapolis, INN822TNRv Missions LLC · St Maries, IDN822TWWoods Douglas A · Franklin, WIN822VTPebble Alternative LLC · Harahan, LAN822VWWetherbee Rodney A · Florence, ORN822WMEdward Buiel Consulting LLC · Wilmington, DEN822WTFlying 808 LLC · Kaunakakai, HIN8230Ja Aviation Services LLC · Kalispell, MTN8234MFontenot Shane B Dr · Jennings, LAN8236ESpringdale Ventures LLC · Ocala, FLN8236UHarris Adam K · Shrewsbury, MAN8237JWilcox Christopher M · Jay, OKN8237QAircon LLC · New Franklin, OHN823CDProfeta Glen A Trustee · Hanford, CAN823DHRo-Jo Scientific Consulting LLC · Indianapolis, INN823EFViperhawks LLC · Jacksonville, FLN823ERV1vr LLC · Wilmington, DEN823FWNyahs Keeper LLC · Portola Valley, CAN823LAN907ds LLC · Palo Alto, CAN823PKBay City Air LLC · Hayward, CAN823PVIyer Swaminathan B · Great Falls, VAN823RBMagaviation LLC · Westwood, MAN823RDJojabella LLC · Jonesboro, ARN823VKPied Pipers Inc · Bradenton, FLN8241NSpecial Services LLC · Magnolia, DEN8242JRegistered aircraftN8243QAnderson Cattle Co Inc · Emporia, KS
Back to AD 2012-10-13