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.
N4163JLoera Josa · Laredo, TXN41641Gunderson Roger · Fort Collins, CON41645Coastal Air Inc · Groton, CTN41648Russell Matthew M · Niantic, CTN41649Air Trek North LLC · South Saint Paul, MNN4164DWalker Richard J · Wasilla, AKN4164HRobertson James I · La Pine, ORN4164JCaister Benjamin M · Saint Clair, MIN4164PSeaplanes R Fun Inc · Wilmington, DEN4164YBoard Of Trustees · Savoy, ILN41650Airmotive Service LLC · Brigham City, UTN41657Morton Zac D · San Antonio, TXN4165EJauer Brant A · Saukville, WIN4165MJones Donald T · Barrigada, GUN4165UInter American University Of Puerto Rico · Bayamon, PRN4165ZHollingsworth Lloyd Dan · Anchorage, AKN41667Lewis Clifton Jack · North Branch, MIN41669Hogan Daniel L · Chapel Hill, NCN4166FStalworth Leasing Inc · Burr Ridge, ILN4166HBird Acquisition LLC · Phoenix, AZN4166MWoolace James L · North Pole, AKN4166RRogers John K · Statesboro, GAN41672Kansas Aviation Museum · Wichita, KSN41674Swift Museum Foundation Inc · Athens, TNN41677Northern Aviation LLC · Palmer, AKN41678Dodge Donald V · Newnan, GAN4167LPlane Nonsense Inc · Middletown, DEN4167ZGolden Arrow Aviation Inc · Wilmington, DEN41681Ralston Michael J · Calhoun, GAN41683Ferraro Jeffrey T · Mckinney, TXN41684Nenahlo Thomas L · Anchorage, AKN41686Atx Aero LLC · Austin, TXN41688Breunig Gerald S · Newark, ILN4168GWeishaar Walter E · Shafter, CAN4168HCordell Brad · Port Charlotte, FLN4168JTwigg Donald A · Cumberland, MDN4168YThree Point LLC · Lacon, ILN41691Whiteknucle Aerobatics Inc · Blacksburg, VAN41693Glasford John T · Rapid City, SDN41694Damiano Charles J · Orcutt, CAN41695Guilfoyle Robert J · Shepherd, MTN41696Aaa Aviation LLC · Donalsonville, GAN41698Collier James R · Castle Rock, CON4169FRoelker Randall S · San Antonio, TXN4169MHaroldson Tyler J · Wasilla, AKN4169NNascimento Robert J · Turlock, CAN4169XNusom William J · Hollis Center, MEN416APKizer Bret · Albany, ORN416CACoast Flight Training And Management Inc · Dallas, TXN416DMMatheny Mitchell M · Saint Augustine, FL
Back to AD 90-04-06 R1