AD 2009-24-13
Registered aircraft · 283
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:2009-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:2009-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:2009-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:2009-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.
N702BDAircraft Guaranty Corp Trustee · Oklahoma City, OKN702FMBizpay Aviation LLC · Missoula, MTN707ELSilver Dollar Partners LLC · Las Vegas, NVN707LLJf Air2021 LLC · Byron, GAN70FAApollo Bay LLC · Wilmington, DEN70KWWilair LLC · Memphis, TNN713YDLfggsd Aviation LLC · Jacksonville Beach, FLN715DLCapital Edge Aviation LLC · Coraopolis, PAN715MEMmp Airflight LLC · Mitchell, SDN716SNCitation Management LLC · Shoal Creek, ALN717HACj2 Investments LLC · Lafayette, LAN718ALDyer Donald E · Austin, TXN722TSSc Aviation LLC · Birmingham, ALN740JSKpna Group LLC · Jacksonville, FLN743JGKing Air 90b LLC · Wauconda, ILN744CBUniversity Of Utah Heath · Ogden, UTN745JSAscend Aero LLC · Carson City, NVN747JJ314 LLC · Del Mar, CAN74JECatalyst Business Advisors LLC · New Castle, DEN750SLGoldwater Aviation LLC · Dover, DEN757CPAps Aviation LLC · North Little Rock, ARN759GJkdb Air LLC · Beaumont, TXN75CHHighland Ventures Ltd · Springfield, ILN775TFTfp Corp · Medina, OHN77NDThunderhawk LLC · Fargo, NDFirst renewal noticeN77VRBlaise Alexander Management Inc · Montoursville, PAN77VZCrusader Air II LLC · Cleveland, TNN783DC812cd LLC · Indianapolis, INN784KSSsi Aviation Group LLC · Eagle, IDN785MTMeans To Go LLC · Altoona, PAN786ACMustang Investors LLC · Eagle, IDN788JSAd Equipment Holdings LLC · Suwanee, GAN78RKRkfl LLC · Boulder, CON800GFCj2 Holdings LLC · Wilmington, DEN807NSClayburn Corp · Beaumont, TXN80CSchwertner Farms Inc · Schwertner, TXN817MPFlybiz LLC · Zeeland, MIN821HPHigh Line Air LLC · Laredo, TXN821PPTerral Riverservice Inc · Lake Providence, LAN823LNapa Aviation LLC · Napa, CAN82BBSon Raes Medical Products Arizona LLC · Phoenix, AZN82VKTnt Leasing LLC · Soldotna, AKN831BDPioneer LLC · Springfield, MON847KKBank Of Utah Trustee · Salt Lake City, UTN851FSSeminole Boosters Inc · Tallahassee, FLN851JBGeneral Services LLC · Sanford, NCN85KMShea Aviation LLC · Chattanooga, TNN866CBClipper Berwick LLC · Leesburg, FLN868CBHarrington Automotive Inc · Ogden, UTN869CKMinnesota Equipment Leasing Services Inc · Blaine, MN
Back to AD 2009-24-13