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.
N617VABueso Travel LLC · Gladstone, ORN6180BNewton Raymond C Jr · Heath, TXN6180NMargiotta Russell A Trustee · Woodside, CAN6183NLewis A Everett Jr · Chico, CAFirst renewal noticeN6184CRegistered aircraftN6185BGust William J DBA · Monument, CON6188XKorotkov Dmitry V · Rocklin, CAN6188YLexington Enterprises Group Inc · San Jose, CAN618ABCss Enterprises Inc · Middletown, DEN618AJCvm Leasing LLC · Angola, NYN618ALDrifting Dirt LLC · Lewes, DEN618BHTkr3 Aviation LLC · Urbandale, IAN618CAHyannis Air Service Inc · Hyannis, MAN618CJYou Are Too Nosey LLC · Wilmington, DEN618JABolle Aviation LLC · Clare, MIN618JLAero Venture LLC · Pasadena, CAN618JPBrown Wings LLC · Palm Beach Gardens, FLN618JRRegistered aircraftN618MBSonic Boom Services Inc · Broad Channel, NYN618MROshaughnessy Stephen M · Littleton, CON618SHCirrus Design Corp · Duluth, MNN618SLCirrus Design Corp · Duluth, MNN618VAToorani Brian B · Irvine, CAN6190LPineapple Aviation LLC · Greenville, NCN6192NDolezal Todd R · San Luis Obispo, CAN6192UKings Nw LLC · Lakewood, WAN6192XSongbird Group LLC · Andover, MNN6193QRedstar Air Shows Inc · Discovery Bay, CAFirst renewal noticeN6195BBoyd Edward Ayres · Coronado, CAN6196NMccarthy Sean P · Siloam Springs, ARN619ALLamc Associates LLC · Fargo, NDN619AWAlpha Whiskey Holdings LLC · New York, NYN619CDSimpson Walker Aviation LLC · Joplin, MON619KGLouises Properties LLC · Huntsville, ALN619MCN619mc LLC · Berkeley, CAN619MJVision Transport LLC · West Bloomfield, MIN619MTMiketango LLC · South Jordan, UTN619PMDm Flying LLC · Lighthouse Point, FLN619PSHp3422 Aviation LLC · Palo Alto, CAN619RDHunt Aviation LLC · Rochester, MNN619RLPlane Addiction LLC · Hopkinton, MAN619SJPonderosa Aircraft LLC · Great Falls, MTN619SMRegistered aircraftN619TPSkyborne LLC · Kaukauna, WIN619TXTtx Air LLC · Sturgeon Bay, WIN619WMKatz Aviation LLC · Riverwoods, ILN61BQEle Motorsports LLC · Dover, DEN61BSKris & B Holdings LLC · Hyrum, UTN61BWWelch William Ben · Danville, ILN61CBWellness Multiplier Inc · Osage Beach, MO
Back to AD 2012-10-13