AD 90-04-06 R1
Registered aircraft · 68,377
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-04-06-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-04-06-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-04-06-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-04-06-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.
N8201ABeggs Daniel · Royston, GAN8201BTammi Mark K · Grass Valley, CAN8201CSheard Scott R · Chugiak, AKN8201GMetzgen Richard A · Groveland, CAN8201NLang Peter J · Coopersburg, PAN8201QEhmka Mitchell · Lombard, ILN8201W8201w General Partnership · Wilbraham, MAN8201XPotter Jan Charles · Tangerine, FLN8201YTorqmation Inc · Houston, TXN82022Hard Luck Aviation LLC · Tok, AKN82023Rodriguez Richard V · Brooklyn, NYN8202CMoore Sharkie A · Houston, TXN8202WN8202w LLC · American Fork, UTN82035Troia Andrew · Homer, AKN8203DVans Holding LLC · Canton, OHN8203GWarne Samuel S · Salisbury, NCN8203NPope Jimmy M Jr · Eastover, NCN8203WCarter Terry A · Clinton, ARN8203YMn98 LLC · Belview, MNN82044Chandler Air Service Inc · Chandler, AZN82045Paris Air Inc · Vero Beach, FLN82048Newton Property Leasing LLC · Greene, IAN8204GLowe Clinton V · Lake Point, UTN8204JKusa Aviation LLC · Beaumont, TXN8204NNielson Rex W · Pendleton, ORN8204WJeffery Gordon Paul III · Kirkland, WAN8204YBlue Steele LLC · Barnegat, NJN82053Kleinknecht Richard C · Burtchville, MIN82054Fusaro Ronald G · Westerly, RIN82057Morelli Michael L · Eagle River, AKN82058Hunt Brackston C · Elaine, ARN8205APilot Place LLC · Sarasota, FLN8205CHasting Grant William · Covington, WAN8205EChandler Air Service Inc · Chandler, AZN8205GYoung Charles D · Athens, TXN8205WShockey Michael J · Dumas, TXN82063Richards Brian W · Soldotna, AKN82064Wells Joseph E · Dorchester, SCN82065Yundt Joshua J · Wasilla, AKN8206BSandoval Joel · San Luis, AZN8206CCalvert Charles W · Ranger, TXN8206WMedia Stew LLC · Carson City, NVN8206YBauer Electric Inc · Winona, MNN82071Vintage Aircraft LLC · Leesville, SCN82075Miloud Chadd K · Fort Worth, TXN82076Kustatan Leasing LLC · Nikiski, AKN8207GKing Paul · Mount Holly, NJN8207NRohner Harlan G · Willmar, MNN8207PReed Thomas F · Wichita, KSN8207TColorado Aircraft Maintenance Solutions LLC · Denver, CO
Back to AD 90-04-06 R1