AD 98-15-13
Registered aircraft · 2,358
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:98-15-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:98-15-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:98-15-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:98-15-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.
N36988Bank Of Utah Trustee · Salt Lake City, UTN369MKKcha LLC · Chattanooga, TNN369MWTextron Aviation Inc · Wichita, KSN369RSEarly Bird Air LLC · Lawrence, MIN369WTSterling John · Port Lavaca, TXN36TGRv Holding LLC · Winchester, MAN3700MBoeing Co · Berkeley, MON37084Bank Of Utah Trustee · Salt Lake City, UTN370CSReach Air Medical Services LLC · Santa Rosa, CAN370UBoard Of Regents Of The University Of Oklahoma · Norman, OKN37172Driscolls Inc · Watsonville, CAN372MCPmc Capair LLC · Philadelphia, PAN373SUTextron Aviation Inc · Wichita, KSN3742B22835 Holdings LLC · Wilmington, DEN374BHResource Solutions & Logistical Support LLC · Mooresville, NCN375BCYellowstone Leasing LLC · Pray, MTN375CPEjs Aviation LLC · Dallas, TXN375JPAir T-Jam LLC · Uniontown, PAN377JEAcr Advertising LLC · Jasper, INN377PUig Transport LLC · Raleigh, NCN377SUTextron Aviation Inc · Wichita, KSN378ATAirtrex Registration Corp Trustee · Wichita, KSN378BGDiscovery One LLC · Windsor, CON379ATAirtrex Registration Corp Trustee · Wichita, KSN379EKAvtrust LLC Trustee · Wilmington, DEN379VMShores Kenneth E · Robstown, TXN37SUTextron Aviation Inc · Wichita, KSN37TDTwin Disc Inc · Racine, WIN3805EHollow Creek Investments LLC · Germantown, TNN3809CRepublic Refrigeration Inc · Monroe, NCN380ATAirtrex Registration Corp Trustee · Wichita, KSN380JPPaalmc Llv · Shreveport, LAN380KMTfg Holdings LLC · Greenville, SCN3818C18 Charlie LLC · Southern Pines, NCN381ATAirtrex Registration Corp Trustee · Wichita, KSN381HCIntermountain Medical Transport LLC · Salt Lake City, UTN381SUTextron Aviation Inc · Wichita, KSN38280Aerotrust Services Corp Trustee · Wilmington, DEN382ATAirtrex Registration Corp Trustee · Wichita, KSN383AAAzul Air LLC · Dover, DEN383ASLee Holdings & Investments LLC · Marks, MSN383ATAirtrex Aircraft Juliet Inc · Wichita, KSN384ATAirtrex Aircraft Kilo Inc · Wichita, KSN385ATAirtrex Aircraft Lima Inc · Wichita, KSN385EMEmerald Aviation Inc · Manassas, VAN385HCs Aviation LLC · Lewes, DEN386ATAirtrex Aircraft Mike Inc · Wichita, KSN386GABarnes Inc · Lewiston, IDN386MNTextron Aviation Inc · Wichita, KSN387ASMurfin Inc · Wichita, KS
Back to AD 98-15-13