AD 2000-23-21
Registered aircraft · 47,138
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:2000-23-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
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:2000-23-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21') 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.
N269ZACirrus Design Corp · Duluth, MNN26AWAntique Aircraft And Automobile LLC · Van Alstyne, TXN26BRStender Aviation B LLC · Huntsville, ALN26BZNorthcutt Chevrolet Buick LLC · Enid, OKN26CFKustatan Leasing LLC · Nikiski, AKN26CRSim International Inc · Fort Mill, SCN26CSJetswiss LLC · Overland Park, KSN26CUAnselmo Jeffery A · Fairfield, CAN26CZCzi LLC · Great Falls, MTN26DEContinental Title Trust LLC Trustee · Wichita, KSN26DLHayden David Bernard Trustee · Roach, MON26DPColibri Ventures LLC · Dorado, PRN26EPErid Air LLC · Blackfoot, IDN26FCRwr Air Inc · Tok, AKN26FFFastfun LLC · Fort Myers, FLN26GRLakeside Capital Holdings LLC · Green Cove Springs, FLN26HAEpsilon Equity Partners LLC · Houston, TXN26HDRed Sky Investments Series LLC Series 1 · Jasper, ALN26KGarrett Robert A · Dallas, GAN26KNSky King Aviation Inc · Weslaco, TXN26LJN26lj LLC · Oklahoma City, OKN26LLGmr Leasing LLC · Lincoln, DEN26MCFoxtrot Squared Aviation LLC · Fairview, TXN26MDMccue Gregory P · Cody, WYN26MGWhitmus Christopher A · Bowie, TXN26MKCga Group LLC · Houston, TXN26MRBenemily Aviation LLC · Flagstaff, AZN26MWMike Whiskey LLC · Atlanta, GAN26MZHva N26mz LLC · Cooper City, FLN26POn Final Flying LLC · Altoona, IAN26PHHuff Peter C · Mckinney, TXN26PMHill Capital Leasing LLC · Scottsdale, AZN26PRSoule Clauson D · Cooperstown, NYN26PVWoods H Ross · El Dorado, ARN26QRSolesbee Nathan Arthur · Anaheim, CAN26RGPlane Fun Inc Tr Trustee · Snellville, GAN26RHHarker Jonathan Kimball · Clarkston, WAN26RSStacey Enterprises Inc · Ogden, UTN26RTInternational Air Services Inc Trustee · Carson City, NVN26SKDevine Robert · Albuquerque, NMN26STSky Condor Aviation LLC · Flatwoods, WVN26TARyan Air Inc · Anchorage, AKN26URDartswift Inc · Philadelphia, PAN26VSBoss Aviation LLC · Douglas, AZN26WRiddle Jay Allen · Gainesville, FLN26WADesert Sky Ventures LLC · Edmond, OKN26WLTrio Leasing LLC · Highland, MIN26WMSportcruiser LLC · Wilmington, DEN26XYSabot Jay M · Naples, FLN26YValiair Lc Trustee · Casper, WY
Back to AD 2000-23-21