AD 2007-24-13
Registered aircraft · 4,026
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:2007-24-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:2007-24-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:2007-24-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:2007-24-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.
N636CPurcell Dave M · Bowling Green, KYN636CTScarpone Aviation LLC · Phoenix, AZN636KBRiviera Glass Flyers Inc - Trustee · Wichita, KSN636STDelavan Emery Lee Jr · Castroville, TXN636TLMasr Plane LLC · Amarillo, TXN637MRDavis Thomas H · Pt Pleasant Beach, NJN638KBIngram Air LLC · Hahira, GAN638SRRabidou Gary R Jr · Lancaster, MAN639CCirrusly LLC · Cheyenne, WYN639SRShelley Leslie I · Temple, TXN63KADickert Investments - Flying Dicks LLC · Cave Creek, AZN63MESky22 LLC · Auburn, ALN640CDRegistered aircraftN640PRjs Aviation LLC · Perryville, MON641SR641sr LLC · Greeley, CON641WTN641wt LLC · Helena, MTN642CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYN642CPDodson International Parts Inc · Rantoul, KSN642SRSafford Robert Owen Jr · Clarksville, TNN642TLBuddy Air LLC · West Bend, WIN643JMSherman Aviation LLC · Haslett, MIN643SRSky Dawgs LLC · Kennesaw, GAN643TFFlyway Aviation Partners LLC · Rogers, ARN644CDKapp LLC · Dallas, TXN644GKCirrus Design Corp · Duluth, MNN644SRBas Part Sales LLC · Greeley, CON645BDFly 645bd LLC · Louisville, KYN645CGainous David C · Port Saint Joe, FLN645CDSkylane LLC · East Hampton, NYN645CPRjgvb LLC · Shippensburg, PAN645EMMcdevitt Aircraft LLC · Naperville, ILN645RSSlack Richard · Highland, UTN645SRArcangel Aviation II LLC · Kansas City, MON6468Charlie Sierra Aviation LLC · Norwalk, IAN646ABInternet Strategies LLC · Glenview, ILN646AFFlight1 Technical Training Services LLC · Myrtle Beach, SCN647CDGomez Enrique Jose · Pinecrest, FLN648ACHey Clinic Pa · Raleigh, NCN648CDurant Cecil John · Arlington, TXN648CB648cb LLC · Columbus, OHN649CDSouthcap Brokerage Altanta Inc · Inlet Beach, FLN64MROne Mike Romeo Leasing LLC · Las Vegas, NVN64TGWilliamson Russell Haire Jr · Memphis, TNN650SREndpoints & Evidence LLC · Surf City, NCN651CPN651cp LLC · Sylacauga, ALN651JRSumar Electrical Systems Inc · Warren, OHN651MMEcr Aviation LLC · Elizabeth, NJN651XCWoodland Air LLC · Grand Rapids, MIN652CDCameronair LLC · Ann Arbor, MIN652JMRed Raider Asset Holdings LLC · Austin, TX
Back to AD 2007-24-13