AD 2003-24-13
Registered aircraft · 7,870
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:2003-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:2003-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:2003-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:2003-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.
N194DDLcb Leasing · Bristow, VAN194SPFly4sp LLC · San Mateo, CAN194THWingsleasing LLC · Wichita, KSN194TWGreenway William Kendal · Greensboro, GAN1955TFredericksen John · Cedarburg, WIN1956VMedary Aviation LLC · Brookings, SDN1957KVan Bortel Aircraft Inc · Arlington, TXN195FAPinkston Pat · Carrollton, ILN195NWNorthwestern Michigan College · Traverse City, MIN1962GGr Aviation LLC · Key Biscayne, FLN1962KMria LLC · Albuquerque, NMN1965HDeltahawk Engines Inc · Racine, WIN196CPCivil Air Patrol · Maxwell Afb, ALN196MEPacific Lease · Elk Grove, CAN196PWC I Mckown & Son Inc · Newton, WVN196SA3d Capture LLC · Beaumont, TXN196TTNbr Aviation · Bristow, VAN196TWTango Lima Flying LLC · Lawrence, KSN197BALewis University · Romeoville, ILN197MCLewis University · Romeoville, ILN197MEPremier Air Of Delaware Inc · Flemington, NJN197TACoast Aviation LLC · Costa Mesa, CAN197WSObr Leasing · Bristow, VAN1982KN1982k LLC · Wilmington, DEN1986VSpeer 182 LLC · Kalispell, MTN198BWFixed Wing Holding Co Inc · Pembroke Pines, FLN198MECal Aggie Flying Farmers · Davis, CAN198PGSun City Aviation LLC · Davie, FLN198RNKqm Aviation · Bristow, VAN198SPFlight Training Aircraft LLC · Wilmington, DEN198THWingsleasing LLC · Wichita, KSN1992DRiggan Russell C · Kirkwood, MON1995BN2jz LLC · Amarillo, TXN1998FSpartan Education Group LLC · Tulsa, OKN1998RA & E Flying Club Of Los Angeles Inc · Hawthorne, CAN199CACapital Holdings 109 LLC · Potomac, MDN199PWJ & C Express Inc · Carbondale, ILN199RAN199ra LLC · Huntington Woods, MIN199SHPrecision Design Inc · Wilmington, DEN199SPW Air LLC · Wheeling, ILN199TEPxw Services · Greenville, DEN19CMRedrock Aviation LLC · Missoula, MTN19DKRichardson Cotton Inc · Wilmington, DEN19HPState Of Ohio Dept Of Public Safety · Columbus, OHN19KHVan Bortel Aircraft Inc · Arlington, TXN19LMM & M Skyshare LLC · Winter Park, FLN19MVSky Path Aviation LLC · Sheridan, WYN19SCSacred Heart Medical Group Inc · Riverside, CAN1FRApex Aero LLC · Kalispell, MTN1LYAll About Lawns Inc · Sebring, FL
Back to AD 2003-24-13