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.
N658CKCke LLC · Dover, DEN658KCKj Hotel Properties LLC · Hollister, MON658MWitherington Properties Inc · Oak Ridge, TNN658TAJse Aviation Operations LLC · Watertown, NYN658WMGround Zero Plumbing & A/C LLC · Gilbert, AZN6591NRickey James R · Hanford, CAFirst renewal noticeN6593WSouthern Aircraft Consultancy Inc Trustee · Casper, WYN6594CMaiden Assets LLC · Norfolk, VAN6597CHai Services Inc · Haltom City, TXN6598AWeisel James M · Santa Cruz, CAN659ACRfa Leasing LLC · Bruce Township, MIN659CCMammolink LLC · New Port Richey, FLN659CTBear Taxi LLC · Tulsa, OKN659JKnier & Associates Inc · Cary, NCN659RMattyair LLC · Holbrook, NYN659RJFoerstel Edward · Miami Beach, FLN65BEStarwood Air LLC · Missoula, MTN65DBrowndog LLC · Lksid Marblhd, OHN65GHEmt Holdings LLC · Leesburg, VAN65HLMurphy Air LLC · Pine Bluff, ARN65KBBurke Daniel P · Oyster Bay, NYN65LKLift Enterprise LLC · Helena, MTN65LLKoochick Inc · Glendale, CAN65LMAero Compression LLC · Macon, GAN65MJPlane Fun Inc Tr Trustee · Snellville, GAN65PDVerhalen Flyers LLC · Marshall, TXN65RPE-Co Aviation LLC · Wilmington, DEN65TCCloud 8 LLC · West Hartford, CTN65TDTsr Aviation LLC · Middletown, DEN65TLLes Chardons Two Inc Trustee · Wilmington, DEN65TYMbessette LLC · West Ossipee, NHN65VRAdams Aviation Services Inc Trustee · Wilmington, DEN65VTAsclepiad Aviation LLC · San Antonio, TXN65XMTail Number Pending LLC · Sheridan, WYN6600LBonanza Partners LLC · Newton Centre, MAN6602CSnip Robert C · Telluride, CON6606YBlackwell Benjamin D · Scottsdale, AZN6609WKingsford Smith LLC · Tulsa, OKN660CABank Of Utah Trustee · Salt Lake City, UTN660DSJsk Flight Service LLC · Dallas, TXN660LTCypress Cove Aviation LLC · Marble Falls, TXN660MKMike Kilo LLC · Atlanta, GAN660R660 Romeo LLC · Tulsa, OKN6611ESpirit Of Faith Family Church · Cedar Rapids, IAN6614CBg Air Corp · Wilmington, DEN6614YBoots LLC · Clay Center, KSN6617CN6617c Inc · Calumet City, ILN661APAllied Potato Express LLC · Bakersfield, CAN661CD15wg LLC · Mobile, ALN661MClearflite LLC · Hurricane, UT
Back to AD 2012-10-13