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.
N8818YSouthern Aircraft Consultancy Inc Trustee · Casper, WYN88191Brown Dennis K · Reno, NVN88194Registered aircraftN88196Speer Jon H · Bryan, OHN8819ETransition Aviation LLC · Hummelstown, PAN881ACFly Twin Comanche LLC · Peoria, AZN881BBBittner Robert A · Pewaukee, WIN881CDWestern Pilot Service Inc · Phoenix, AZN881DCGoldfarb Martin · Scottsdale, AZN881DSSeltman Jack A · Wichita, KSN881FTFlorida Institute Of Technology · Melbourne, FLN881GPPuckett Gregory N · Vesuvius, VAN881JBHammer Roger W · Seattle, WAN881JRFinnegan Brian E · Waterloo, IAN881KBAero Quest LLC · Olive Branch, MSN881LSNichols John B · Mena, ARN881MAHunt William E · Helena, MTN881PUTrustees Of Purdue University · West Lafayette, INN881RDOrchard Richard W · Sagle, IDN881RVKeeslar David L · Sturgis, MIN881RWWilliams Summit LLC · Salmon, IDN881TAMcgough Julie E · Red Oak, TXN881WABlahut Robert John · Prosser, WAN88200Auer William E · Saint Petersburg, FLN88202Moore David J · Beechgrove, TNN8820CPfaff Kirk J · Jamul, CAN8820DMayo Jesse J · Fairbanks, AKN8820EDishman John David · Brooklyn, NYN8820JSurles Willian T · Chuckey, TNN88214Mcclanahan John B · Fayetteville, GAN88215George Gary D · Humble, TXN8821ERegistration Pending · Dothan, ALRegistration pendingN8821FRuhlman Dan C · Youngsville, PAN8821JJanssen Brittney Juen · Pleasantville, IAN88223Mather Don A · Sandusky, OHN88225Horst Aviation LLC · New Holland, PAN88227Acadian Dusters LLC · Church Point, LAN8822CSeaton Carsten T · Fairbanks, AKN8822DWhite Glen A · Timber, ORN8822NFirestine Joseph W · Atwater, CAN88230Smithson Charles W · Wasilla, AKN88233Dupont Larry W · North Hero, VTN88237Bas Part Sales LLC · Greeley, CON8823CMcgee David · West Monroe, LAN8823FHudson Valley Helicopters Inc · Wilmington, DEFirst renewal noticeN8823JBas Part Sales LLC · Greeley, CON8823NAvia Flight Academy · Stratford, CTN8823PSite Solutions LLC · Bottineau, NDN8823YFerrara John M · Newtown, PAN88241Walters Eugene H · Maupin, OR
Back to AD 90-04-06 R1