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.
N624RPMaho Bay Partners LLC · Newark, DEN624RSSr22 Delta Hotel LLC · Lafayette, LAN624SABout Bertram J Trustee · Los Gatos, CAN624SRN3809 Kilo LLC · Wilmington, DEN624TELenbob Aviation LLC · Southaven, MSN624VAEkl Aviation LLC · Oklahoma City, OKN624YSnc Investments LLC · Mesa, AZN6255JAzimuth Aviation LLC · Mechanicsburg, PAN6258NTango Victor Aviation LLC · Kingsburg, CAN625CBPowers Brothers Real Estate · Henderson, TXN625CDTurner David C · Clinton Township, MIN625HWBsw Acceptance Inc · Muleshoe, TXN625JLTurbulent Returns LLC · Minneapolis, MNN625JSJsl Aviation LLC · Nashville, INN625LEKeystone Flyers LLC · Brevard, NCN625LKB8 LLC · Florence, ORN625SMAstute Wing Inc Trustee · Wilmington, DEN625TBGeneral Aerospace Co LLC · Great Falls, VAN625TRVictor Pathways Management LLC · Newport Beach, CAN625VSHeritage Airplane One LLC · Tullahoma, TNN6262KBrz Air LLC · Beaumont, TXN6267YZero Four Twelve LLC · Clovis, NMN6269NJuliet Tango Capital LLC · Saginaw, MIN626BGAmazing Concepts LLC · Thousand Oaks, CAFirst renewal noticeN626DPCockpitto LLC · Acampo, CAN626EEBedichek Robert C · Covina, CAN626FPlane Fun Inc Tr Trustee · Snellville, GAN626HHFlightline II LLC · Little Rock, ARN626HMRb Aviation LLC · Tyler, TXN626JBBank Of Utah Trustee · Salt Lake City, UTN626MEAero Middleton LLC · Belleville, WIN626MTEmtac Sr20 LLC · Palm Beach, FLN626PTDriven Equity LLC · Grand Junction, CON626PZBaja Bay Club LLC · Irvine, CAN626REAv Air Lease LLC · Albuquerque, NMN626RFFranklin Air LLC · West Palm Beach, FLN626SGChewning Charles Steven Trustee · Cary, NCN626SRPf Aviation LLC · Birmingham, ALN626TRWevob LLC · Thomasville, GAN626TTNacho Plane LLC · Provo, UTN6270XLees Robert A II · Mesa, AZN6271BCountry Flyin Inc · Homestead, FLN6274AA V T210 LLC · Palmdale, CAN6276XWj Bolton Farms LLC · Mark Tree, ARN6277ZAircraft Guaranty Corp Trustee · Oklahoma City, OKN6278YTown & Country Aviation LLC · Sunnyvale, CAN627HECrinkle Aviation LLC · Indianapolis, INN627PMRichardson David J Trustee · West Memphis, ARN627PWSattofas Air LLC · Gilbert, AZN627RGSummer Flight LLC · Selbyville, DE
Back to AD 2012-10-13