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.
N7264HDelta Sierra Aviation LLC · White Salmon, WAN72653Atp Aircraft 2 LLC · Wilmington, DEN72658Tidewater Flying Club Inc · Newport News, VAN7265BHolladay Aviation LLC · Jacksonville, FLN7265REmerald City Aircraft Leasing Inc · Port Orchard, WAN7265YAv8r LLC · Manchester Center, VTN7265ZAtp Aircraft 2 LLC · Wilmington, DEN72662Jwa Flight School LLC · Bolingbrook, ILN72664Advanced Aviation Group LLC · Frederick, MDN72667Rro Leasing LLC · Grand Forks, NDN72669Mid-Island Air Service Inc · Ronkonkoma, NYN7266BButtonwood Construction LLC · Islamorada, FLN7266MFerrarer Joseph H Trustee · Glendora, CAN7266NBeck Robert A · Cove, ORN7266YAvero Aviation LLC · Dover, DEN7266ZBearing Tree Land Surveying LLC · Oklahoma City, OKN72671Vfr Aircraft And Training LLC · Jackson, MON72675Chapel Hill Flying Club Inc DBA · Sanford, NCN7267TDmcc LLC · Lewes, DEN7267YVolatilis Aviation LLC · Collinsville, ILN7267ZHoffpauir Jeremy · Broussard, LAN72689Brown Nathan · Snellville, GAN7268FFarber Gerald · Las Cruces, NMN7268GSteel & Supply Co LLC · Pensacola, FLN7268KFelts Field Flying Club · Spokane Valley, WAN7268PSurdex Corp · Chesterfield, MON7268Y612 Holdings Lp · Decatur, TXN7268ZWestwind Aviation Inc · Phoenix, AZN72692Mccurdy Dwight B · Anderson, INN7269416 Sandals LLC · Tuscaloosa, ALN72695Surdex Corp · Chesterfield, MON72696Bass Adventures LLC · Anchorage, AKN72697Cbt Aviation LLC · Bellingham, WAN7269BReece Vance · Winnsboro, TXN7269CCollins Carliss Alvin · Andrews, TXN7269KDeatley Crushing Company Inc · Lewiston, IDN7269TAg N7269t LLC · Salt Lake City, UTN7269XCummings Cove Air LLC · Gloucester, MAN726CPCivil Air Patrol · Maxwell Afb, ALN726ECHeritage Aviation Management Ltd · Conroe, TXN726EREmbry-Riddle Aeronautical University Inc · Prescott, AZN726GMNby Productions · Bristow, VAN726LUTextron Aviation Inc · Wichita, KSN726MPBryant Darrell · Treasure Island, FLN726SAInternational Air Services Inc Trustee · Carson City, NVN7270HSundowners Inc · Fort Myers, FLN7270QGrey-Gc LLC · Picayune, MSN7270YBlanton Kenneth A Jr · Cortland, NYN7271XAeolian LLC · Mcalester, OKN7271YVitatoe Industries Inc · Chillicothe, OH
Back to AD 2003-24-13