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.
N8354RStonebrink Grant · Boonton, NJN8354WCoombs Eric S · Louisburg, NCN8355AEmerald City Aircraft Leasing Inc · Port Orchard, WAN83566Downes Dennis G DBA · Saltsburg, PAN8356ESky West Aviation Inc Trustee · Albuquerque, NMN8356JWissam Habbal · Rosamond, CAN8356REmerald City Aircraft Leasing Inc · Port Orchard, WAN8356VGroh David A · Mason, MIN8356WSmith Randall K · Wilton, CAN83572Pacific Aviation LLC · Cottage Grove, ORN83573Frazier Aviation LLC · Ontario, ORN83577Ennen Rick M · Bottineau, NDN83579Mak Air Ventures LLC · Smithfield, NCN8357RRegistration Pending · Fort Worth, TXRegistration pendingN8357VHaas Daniel S · Camarillo, CAN83580Lazy Ye Cattle Co · Dodson, MTN83582Johnson Gavin Howard · Anchorage, AKN8358FHolt Helicopters Inc · Uvalde, TXN8358LOc Flight Lessons LLC · Costa Mesa, CAN8358MSky Blue Holdings LLC · Park City, UTN8358RHight Mayon C · Snohomish, WAN8358WChaney Eddie L · Douglas, GAN8358YGruenbaum Michael S · Eastvale, CAN8358ZMinella Frank A · Old Forge, PAN83594Sjogren Risto L · Felton, CAN83596Carlson Farms Inc · Plentywood, MTN83598Liley Diana H · Anchorage, AKN8359VCressman Scott M · Mount Pleasant, TXN8359WMarble Jere D · Dayton, NVN8359YManyak Louis J · Inglis, FLN835ATDot Aviation LLC · Wilmington, DEN835BCShoreline Home Services Inc · Wilmington, NCN835SSpirit Of Flight LLC · Noblesville, INN835SHBuell Travis W · Harper, TXN835SWBrakey Richard F · Amarillo, TXN836Furnari Jonathan P · Whitewright, TXN83604Crowe Kirby H · Haskell, OKN8360RSan Diego Community College District · San Diego, CAN8360VGcgk Air Ventures LLC · Sheridan, WYN8360YOtto Aviation LLC · Gilbertsville, PAN8361LMolid Robert J · Dubuque, IAN8361WBursch Clint Lee · Bird City, KSN83620Philippi Joseph E · Judith Gap, MTN83622Trans Crafts LLC · Big Lake, AKN83628Gibson Stanley · Draper, UTN83629Du Clos Paul R III · Anchorage, AKN8362LEmerald City Aircraft Leasing Inc · Port Orchard, WAN8362PBooth Jason D · Timber Lake, SDN8362RCore Flight Academy LLC · Asheboro, NCN8362WSexton Rick C · Payson, AZ
Back to AD 90-04-06 R1