AD 98-17-01 R1
Registered aircraft · 1,201
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-17-01-R1')
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-17-01-R1')
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-17-01-R1') 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-17-01-R1') 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.
N501RSN501rs Aircraft Inc Trustee · Carson City, NVN504CPIntegrity Air LLC · Jefferson, TXN504EDPork N Aviation LLC · Klamath Falls, ORN504STSdt Air Delaware LLC · Wilmington, DEN504TAviationiq LLC · Helena, MTN505GJMed Air LLC · Wilmington, DEN508RZGeaux Flight LLC · Baton Rouge, LAN50FGRegenerative Sports Tissue Bank Inc · Lawrenceville, GAN50FNGh Equipment LLC · Wilmington, DEN50HNN45zf LLC · Wilmington, DEN50KDPw Transport LLC · Lafayette, LAN50KLLiberty Leasing V LLC · Melbourne, FLN50LJWorldwide Aircraft Services Inc DBA · Tampa, FLN50NMN50nm LLC · Dover, DEN50SNFirst Quality Falcon LLC · Great Neck, NYN50SQCfwm LLC · Destin, FLN50TW17 Aviation LLC · Oklahoma City, OKN50XYPb Tri-Jet LLC · Wilmington, DEN50YPVillages Equipment Co · Leesburg, FLN510MPPark Avenue Aircraft Trust LLC Trustee · Dover, DEN510SDChg Jets LLC · Orange, CAN511JCIntermodal Air LLC · Frankfort, ILN511KDBank Of Utah Trustee · Salt Lake City, UTN511RSVmrfalcon50 LLC · Evans, GAN5123Tpi Aircraft Interiors LLC · New Bern, NCN513BEH800 IV LLC · Stuart, FLN513SKHappy Skies LLC · Dover, DEN513TSGully Air LLC · College Station, TXN514MBMcl Falcon LLC · Chicago, ILN515CSCasavia Corp · Wilmington, DEN515CYPacwest Aerodyne LLC · Tualatin, ORN516MXBank Of Utah Trustee · Salt Lake City, UTN516THHippo Air LLC · Grants Pass, ORN518SBGba Legacy LLC · Hopkins, MNN519EMMid-South Investments LLC · Magnolia, ARN51FNGh Equipment LLC · Dover, DEN51JVSky Global LLC · San Juan, PRN520CKLancaster Travel And Leisure Inc · Lancaster, PAN520TCDodson International Parts Inc · Rantoul, KSN521FLIfl Group Inc · Waterford, MIN521JKSale Reported · Beverly Hills, CASale reported, canceledN526SMLucken LLC · Kalispell, MTN527PAPhoenix Air Group Inc · Cartersville, GAN527SRedleaf Management Company LLC · Miami, FLN528LButler National Inc · Olathe, KSN530SEHill Country Jet Partners LLC · Spicewood, TXN534HHec Aviation LLC · Shelbyville, TNN535PSTeam Aero LLC · Olathe, KSN537XX945hc LLC · Cypress, TXN53BCDttb LLC · Memphis, TN
Back to AD 98-17-01 R1