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.
N423Shafer Robert T · Grosse Ile, MIN4230JPleasant Valley Aviation Inc · Bellefonte, PAN4230QAir Castles LLC · Ozark, ALN4230ZBishop Mike · Rifle, CON42312Swinehart Frank E · Lock Haven, PAN4231JBielusiak Stanley J · Dartmouth, MAN4231MHarloff David F · Lehigh Acres, FLN42321Olson Richard Allen · Weatherford, TXN4232FSekel David A · San Diego, CAN4232HHupp Garrett · Sunbury, PAN4232JN4232j LLC · Waialua, HIN4232MHardy Willard H Jr · Lincolnville, MEN4233MJordan Lee · Dickinson, TXN4233QWoods John B · Anchorage, AKN4233TSmith Michael L · Lakeland, FLN4233ZThompson Lee B · Anchorage, AKN4234HKacprzak Dominik · Kingwood, TXN4234JHomerun Horizons LLC · Weatherford, TXN4234QFarr Everett L III · Bensalem, PAN4234TParsons Donald Jr · Crumpler, NCN4234ZLueking Clyde F · Holdrege, NEN42358Bakker Margaret E Trustee · Petaluma, CAN4235HJunker Gregory G · Cincinnati, OHN4235JBarrett Kevin M · Pittsburg, TXN42361Lima 001 LLC · Muscatine, IAN42362Francis Ellis H Jr · South Hill, VAN42363Harrison Kent B · Grass Valley, CAN4236HMakar Michael J · Anchorage, AKN4236MLehman Robert J · Marissa, ILN4236ZMinnehan Joseph T · Joplin, MTN4237HHolden Daniel N · Anacortes, WAN4237JMoppert Stephen Kyler · Madison, MSN4237TPeak 2 Peak Enterprises LLC · Sebring, FLN4237ZYorgason Ty C · Worland, WYN4238FAviation Trust Company LLC · Oklahoma City, OKN4238MRobinson Eric C · Palmer, AKN4238QFisch Markus J · Rock Falls, ILN4238TChopper Aviation LLC · Cahokia Heights, ILN42396Lawrence Jack C Jr · Saint Augustine, FLN42399Reece Rebecca H · San Angelo, TXN4239HGray Steven Don · Tualatin, ORN4239POneal Hollis R · Deridder, LAN4239QElizabeth City State University · Elizabeth City, NCN4239WSmith James W · Newtown, CTN4239ZLsk Aviation Corp · Wilmington, DEN423CKBounds Keith A · Thomson, GAN423CZRutan Aircraft Flying Experience · Waller, TXN423DMGga N423dm LLC · Glendale, AZN423FLIglewski David W · Muskego, WIN423FPUtah State University · Logan, UT
Back to AD 90-04-06 R1