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.
N404YGAviation Trust Company LLC · Oklahoma City, OKN4051CSky High Ventures LLC · Bartlett, TNN4057CAberdeen Flying Service · Aberdeen, SDN405CDLbi Aviation Corp · Manahawkin, NJN405KCS H S Corporation · Indianola, IAN405MKLbo N405mk LLC · Littleton, CON405SRAircraft Guaranty Corp Trustee · Oklahoma City, OKN406BKN406bk LLC · Nantucket, MAN406CConstantine Jeffrey C · Charlotte, NCN406DWPerry Aviation LLC · Spokane, WAN406GAHyannis Air Service Inc · Hyannis, MAN406JCWz Aviation LLC · Missoula, MTN406PKAirwolf Odysseys LLC · Lewistown, MTN406RCIsland Flights Inc · Wilmington, DEN406SRPaulus Kurt W Trustee · Delaware, OHN4079ABrockhoff Jonathan Allen · Sanford, NCN4079CCalled To Care Residential Facility LLC · Avondale, AZN407CDKelly George Sumner · Columbus, GAN407DMPhillips Consulting Group Inc · Wilmington, DEN407KMGough Tecnologies Inc · Winston Salem, NCN407KPDelta Consulting & Real Estate LLC · Manila, ARN407PCOversquare LLC · Norman, OKN407ST5x Sr22 LLC · Sandy Springs, GAN40855Covey Stephen B · Manvel, TXN408CDKc Jet Sales LLC · Scottsdale, AZN408KMRivers Aviation LLC · Houston, TXN408PGJs Extra 300 LLC · Dallas, TXN408RFFogel Services Inc · Ladson, SCN408WGBlue Sky 408 LLC · Lakeland, TNN408WTTrophy Adventures LLC · Bondurant, IAN4091GRobinson Brant Fitzgerald · Powder Springs, GAN4093EDmkr LLC · Coronado, CAN409BKHyannis Air Service Inc DBA · Hyannis, MAN409CDArmbruster LLC · Amherst, OHN409SJKirsh & Kirsh P C · Indianapolis, INN409TTMad Dog Air LLC · Spotsylvania, VAN40CFG&M Flyers LLC · Wilmington, DEN40CYGross William Patrick · Pine Bluffs, WYN40GBSlb Enterprises LLC · Newark, DEN40GDSimply Living LLC · Fort Myers, FLN40NFTroposphere Holding LLC · Austin, TXN40PGFunanich Jon J Trustee · Fairfield, CAN40PMFlypie Industries LLC · Hudson, WIN40SKSides Family Management LLC · El Paso, TXN40SSAdams Aviation Services Inc Trustee · Wilmington, DEN40YMN40ym LLC · Mattituck, NYN4102LWiplinger Robert D · Inver Grove Height, MNN4104T4a Legacy Enterprises LLC · Mcallen, TXN410ABBloxsom Allan P III · Boerne, TXN410ASBase Aviation LLC · Murfreesboro, TN
Back to AD 2012-10-13