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.
N4027XMinor Joann M Raimond · San Diego, CAN40283Keech Mark A · Fairbanks, AKN40286Dwm55 LLC · Kalispell, MTN4028HSanoski Gregory G · Talkeetna, AKN4028ZFlower Pot Cattle Co LLC · Arlington, AZN40291Filho Aniz Rasslan · Erie, CON40294Reese Steven A · Shoreline, WAN40297Chupp Titus · Clark, MON4029BDiebel Dean L · Orlando, FLN4029MCochrane Timothy A · Chippewa Lake, OHN402AArcher Aircraft LLC · Wilmington, DEN402BDMartin Matthew J · Arlington, TXN402BLPiper Aircraft Inc · Vero Beach, FLN402DSDelaware State University · Dover, DEN402ECWaterlanding LLC · Missoula, MTN402ERLeighnor Aircraft LLC · Prescott, AZN402HHilbert Robert C · Marengo, ILN402MReyner Mark D · Los Lunas, NMN402PEDiegos Pet Rescue LLC · Orlando, FLN402PKMitchell John J · Whitewater, WIN402RVMaggard Brent · Edwards, CAN402SBejvan David E · Milwaukee, WIN402WBNew England Airlines Inc · Westerly, RIN403Pescatore Thomas F · Monte Vista, CON4030Rolanco Farms · Parker, AZN4030CAdcock Corey J · Victoria, TXFirst renewal noticeN4030MVan Bortel Howard G · Victor, NYN4030UEagle Services Inc · Washington, MIN4031PGarrett Randy L · Pensacola, FLN4031WBering Pacific Ranches Ltd · Foothills AbN4032PTinny Twister Aviation LLC · Fort Myers, FLN4033TCrop Doctors LLC · Micanopy, FLN4033XMcbride William M · New Castle, DEN4033ZSale Reported · Port Alsworth, AKSale reportedN4034PKoenig William J · Benedict, MDN4034XPrivus Inc · Brooklyn, NYN40353Emerald City Aircraft Leasing Inc · Port Orchard, WAN4035NTodd Steven G · Binghamton, NYN4035RMoreau Donald G · Dayton, TXN4035ZPeninsula Aero Technology Inc · Kenai, AKN4036ERieger John R · Plevna, MTN4036NJestice Manuel P · Ryder, NDN4036PFiegel Donald H · Ward, ARN4036RN4036r LLC · Quinton, ALN4036ZHockey Puck LLC · Big Lake, AKN40374Solo Exteriors Co LLC · Seminole, TXN4037EMathews Brett G · Platte City, MON4037MJensen Mitchell D · Coeur D Alene, IDN4037PLivernois Douglas H · Melrose, FLN4038HWilliams Rourke Co · Fairbanks, AK
Back to AD 90-04-06 R1