AD 96-03-13
Registered aircraft · 1,042
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:96-03-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:96-03-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:96-03-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:96-03-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.
N351KBKabco Aviation LLC · Boaz, ALN351SAGuardian Flight LLC · Lewisville, TXN3532North Delta Ag Aviation LLC · Sledge, MSN3536Vantage Aviation USA LLC · Tampa, FLN3538New Mountain Aviation LLC · Englewood, CON3539Thacker Aircraft Holding LLC · Lubbock, TXN357CCWhitestone Aviation LLC · Orlando, FLN3606TSunshine Aero Industries Inc · Crestview, FLN360BLBachman Aviation LLC · Independence, IAN360EASai Flight Services Inc · Greer, SCN360XNavecord Institute · Wilmington, DEN361EAAlcyone Trust Corp Trustee · Wichita, KSN361KABehrens Investments Of Wisconsin LLC · Waukesha, WIN361TDSequoia Beverage Co Lp DBA · Visalia, CAN3620MSanford Medical Center · Sioux Falls, SDN363DFreeman Holdings Of West Texas LLC · Medford, ORN363JHBering Air Inc · Nome, AKN36987Westflight LLC · Yuma, AZN370CSReach Air Medical Services LLC · Santa Rosa, CAN370PRPuerto Rico International Airlines Inc · San Juan, PRN372JBUltra Property Acquisitions LLC · Edinburg, TXN375JPAir T-Jam LLC · Uniontown, PAN377JEAcr Advertising LLC · Jasper, INN378ATAirtrex Registration Corp Trustee · Wichita, KSN378SFTrigg David D · Houston, TXN379ATAirtrex Registration Corp Trustee · Wichita, KSN379EKAvtrust LLC Trustee · Wilmington, DEN3809CRepublic Refrigeration Inc · Monroe, NCN380ATAirtrex Registration Corp Trustee · Wichita, KSN380JPPaalmc Llv · Shreveport, LAN381ATAirtrex Registration Corp Trustee · Wichita, KSN381HCIntermountain Medical Transport LLC · Salt Lake City, UTN381RUc Aviation Holdings LLC · Union City, TNN382ATAirtrex Registration Corp Trustee · Wichita, KSN383ATAirtrex Aircraft Juliet Inc · Wichita, KSN383JPAtlanta Air Charter Inc · Kennesaw, GAN384ATAirtrex Aircraft Kilo Inc · Wichita, KSN385ATAirtrex Aircraft Lima Inc · Wichita, KSN389RAAirtrex Aircraft Xray Inc · Wichita, KSN38JVKcsi Aerial Patrol Inc · Bakersfield, CAN38VSNv5 Geospatial Inc · Sheboygan Falls, WIN390RHAlpine Aviation Inc · Provo, UTN390SPState Of Arkansas · Little Rock, ARN393JWGeneration Jets LLC · Denison, TXN395AMHollan Air LLC · Amarillo, TXN396MFRango Aviation LLC · Mesa, AZN399ALBallard Aviation Inc · Newton, KSN399CZN399cz LLC · Milwaukee, WIN399TWArx Air LLC · Windermere, FLN39TNDenaina Leasing Agency LLC · Anchorage, AK
Back to AD 96-03-13