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.
N2691YLa Paz Holdings LLC · Wetumpka, ALN2692LInnovative Aviators LLC · Norman, OKN2693BDiaz Charles · Ogden, UTN2694HRockingham Carriage Services Inc · Greenland, NHN2696HSunwest Aviation Inc · Santa Ynez, CAFirst renewal noticeN2696PBlue Wing Aviation LLC · Tulsa, OKN2696UBlack Dragon Consulting LLC · Phoenix, AZN2699DN2699d Corp Trustee · Wilmington, DEN269JMPatterson Larry Jay · San Angelo, TXN269KTJfa Aviation Group LLC · Pompano Beach, FLN269PCSch Aviation Inc Trustee · SporleN269PGSovereign Souls Aviation LLC · Montecito, CAN269PLMerrill Mark · Ellensburg, WAN269R219 Air LLC · South Bend, INN269WTWillis James A · South Jordan, UTN269ZACirrus Design Corp · Duluth, MNN26BZNorthcutt Chevrolet Buick LLC · Enid, OKN26CFKustatan Leasing LLC · Nikiski, AKN26CSJetswiss LLC · Overland Park, KSN26CZCzi LLC · Great Falls, MTN26DPColibri Ventures LLC · Dorado, PRN26FFFastfun LLC · Fort Myers, FLN26HAEpsilon Equity Partners LLC · Houston, TXN26HDRed Sky Investments Series LLC Series 1 · Jasper, ALN26KNSky King Aviation Inc · Weslaco, TXN26MCFoxtrot Squared Aviation LLC · Fairview, TXN26MKCga Group LLC · Houston, TXN26MRBenemily Aviation LLC · Flagstaff, AZN26MWMike Whiskey LLC · Atlanta, GAN26MZHva N26mz LLC · Cooper City, FLN26PMHill Capital Leasing LLC · Scottsdale, AZN26QRSolesbee Nathan Arthur · Anaheim, CAN26RGPlane Fun Inc Tr Trustee · Snellville, GAN26RSStacey Enterprises Inc · Ogden, UTN26SKDevine Robert · Albuquerque, NMN26STSky Condor Aviation LLC · Flatwoods, WVN26VSBoss Aviation LLC · Douglas, AZN26WRiddle Jay Allen · Gainesville, FLN26WADesert Sky Ventures LLC · Edmond, OKN26WMSportcruiser LLC · Wilmington, DEN26XYSabot Jay M · Naples, FLN26YTCtd Management LLC · Easley, SCN2702LE D Santos & Associates LLC · Wilmington, DEN2702VAtx Aero LLC · Austin, TXN2704NKimberton Corp LLC · Phoenixville, PAN2704SC&M Asset Management LLC · Owasso, OKN2704UMatheson Thomas Blair · Mandan, NDN2705LLt Aviation LLC · Plattsmouth, NEN2706AFlhs LLC · Cedar Park, TXN2706TDodson Internarional Parts Inc · Rantoul, KS
Back to AD 2012-10-13