AD 89-22-01 R1 L
Registered aircraft · 1,179
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:89-22-01-R1-L')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:89-22-01-R1-L')
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:89-22-01-R1-L') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:89-22-01-R1-L') 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.
N488BCButte 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, IDFirst renewal noticeN4KAAmbrose 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, DEN500NRAycd LLC · Allentown, PAN500USYarak Aviation LLC · Big Timber, MTN5010KHayward Enterprises Inc · High Point, NCN5010PMarkov Michael J · Oceanside, CAN5013GHmc Lift LLC · Wilmington, DEN50178Analar Corp · Princeton, NJN5017GHelimontana.Com LLC · Livingston, MTN501HVHelivision LLC · Concord, NCN501JSShelby County Sheriffs Office · Columbiana, ALN501TATomlinson Aviation Inc · Ormond Beach, FLN502NSNational Aeronautics And Space Administration · Houston, TXN503WL&T Aviation Inc · Frederick, MDN504EHWest Valley Aviation Inc · Five Points, CAN5052HObrien Helicopters Inc · Lehigh Acres, FLN505RLOrgis Bj · Hallettsville, TXN505TVChemair Helicopters Inc · Jefferson, WIN508XSSouthern Aircraft Consultancy Inc Trustee · Casper, WYN50TVJet Ranger LLC · Cuyahoga Falls, OHN512SCSan Juan Aviation LLC · Wilmington, DEN514RLSlikker Flying Service Inc · Buttonwillow, CAN515BGMonmouth County Shade Tree Commission · Freehold, NJN516LERotor Republic LLC · Orlando, FLN518ZRotormate LLC · Royse City, TXN520MDerstine Air Service LLC · Souderton, PAN522MAProvine Helicopter Service Inc · Greenwood, MSN526HAHelo N526ha LLC · Richmond, VAN528HPCollective Ag LLC · Osceola, NEN52AEAir Evac Ems Inc · O Fallon, MON52BHNipper Troy R · Texarkana, TXN52FAZma LLC · North Little Rock, ARN52GHPleasant Gap Land Co Inc · State College, PAN52PLParatus Air DBA · Auburn, INN52ZSouthern Helicopter Service Inc · Millington, TN
Back to AD 89-22-01 R1 L