AD 90-13-01 R1
Registered aircraft · 1,150
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:90-13-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:90-13-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:90-13-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:90-13-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.
N431CAChem-Air LLC · Shreveport, LAN4328Aircraft Guaranty Corp Trustee · Oklahoma City, OKN432TVSky Choppers LLC · Seneca, KSN4338DAce High Helos LLC · Louise, TXN433HAHelo N433ha LLC · Richmond, VAN43681World Trade Enterprises LLC · Lucas, TXN43AEAir Evac Ems Inc · O Fallon, MON43HHJohnson Flying Service LLC · Exira, IAN4445HBell Textron Inc · Fort Worth, TXN444TVScotts Helicopter Service Inc · Le Sueur, MNN4452Bravo Aviation LLC · Chicago, ILN447JBJbi South Leasing LLC · Pembroke, NHN448EAEdgefield Aviation LLC · Sandy, ORN449EAEdgefield Aviation LLC · Sandy, ORN449SS & L Farm And Ranch LLC · Georgetown, TXN44BCRiggs Rock A · Lake Mary, FLN452MCCitrus County Mosquito Control District · Lecanto, FLN453RARanger Aviation Leasing LLC · Wilmington, DEN454MSCb Couch Inc · Walcott, ARN455TVCox Paul G DBA · Bryce, UTN4569U S Army · Ft Rucker, ALN461RARanger Aviation Leasing LLC · Wilmington, DEN463RARanger Aviation Leasing LLC · Wilmington, DEN468RLMarks Lloyd L · Lafayette, LAN4717WSeven Whiskey LLC · Austin, TXN472MRight Brother Aviation LLC · Chaffee, NYN476KAN476ka LLC · Wasilla, AKN477SDHigh-Lead Helicopters LLC · Mossyrock, WAN47HHJkt LLC · Douglas, WYN4833Gm Leasing Co LLC · Broussard, LAN483RVan Horn Aviation LLC · Tempe, AZN4846G M Leasing Co LLC · Broussard, LAN48552Brown Helicopter Inc · Pensacola, FLN488BCButte County Sheriffs Office · Oroville, CAN48AEAir Evac Ems Inc · O Fallon, MON48HHVarney Aviation LLC · Bangor, MEN490WMSouth Florida Water Management District · West Palm Beach, FLN49589North Wind Aviation LLC · Chelan, WAN49651Withrotor Aviation Inc · Lakeview, ORN49660Provell Chris J · Rio Linda, CAN499WMAgricultural Air Services LLC · Jupiter, FLN49TVHawke Aircraft Holdings Inc · Sandpoint, IDN4KAAmbrose Group Inc · Bellevue, WAN5000BAir Flite Inc · Shawnee, OKN5000GTimberland Helicopters Inc · Ashland, ORN5001KMontana Air Tankers LLC · Three Forks, MTN50046Orlando Aircraft Sales LLC · Orlando, FLN5005NAircoastal Helicopters Inc · Lantana, FLN5007FPatriot Aviation Inc · Greenville, DENon-citizen corporation, flight hours not reportedN5008KL&R Investment Partners LLC · Wilmington, DE
Back to AD 90-13-01 R1