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.
N7067YCactus Skybolt Aviation LLC · Athens, ALN7068DDebach Mike J · Troy, PAN7068QWestwind Aviation Inc · Bremerton, WAN7068YAdvanced Aircrew Training LLC · Nashua, NHN70699Cencer Kevin J · Clear Lake, MNN7069BHarper Bryan K · Junction City, ORN7069GAjf Enterprises LLC · Des Moines, IAN7069KPlatinum Commercial Company LLC · Platinum, AKN7069QFlakker Michael E · Gold Hill, NCN7069RMccoy Evan Tyler · Tullahoma, TNN7069WBirmingham Michael F · Goldsboro, NCN706BHSilver Lance Aviation LLC · Ketchum, IDN706BKBishop Kevin A · Dana, INN706CBMetal Feathers Inc · Ovilla, TXN706CFRegistered aircraftN706DAFlycarolina LLC · Charlotte, NCN706DEBradley Aircraft Company LLC · Columbus, INN706FLTime Flys Idaho LLC · Clarkston, WAN706KSSzmania Kris J · Rossford, OHN706LA4 Winds Consulting LLC · Nashua, NHN706LGRegistered aircraftN706NDUnd Aerospace Foundation · Grand Forks, NDN706QRegistered aircraftN706RAChristiansen Aviation LLC · Wilmington, DEN706RPPuckett Rex L · Silver Creek, GAN706TGauntlett Robert Michael · Yukon, OKN706UBMaliskey Paul D · Au Gres, MIN706WCChilcott Bart L · Derby, KSN7070GGade Christopher P · Williston, VTFirst renewal noticeN7070PHytry Randal G · De Soto, WIN7070RRegistration Pending · Seward, NERegistration pendingN7070VCraven Bradley A · Logansport, INN7070WFullerton Brice · Oroville, WAN7070YBean James P · Tulsa, OKN70714State Of Alaska · Anchorage, AKN70718Youkey John N · Yuma, AZN7071GWings Over Texas Holdings LLC · Denton, TXN7071JMorales Felipe E · San Antonio, TXN7071QSun Country Aero Club · The Villages, FLN7071RKarabulut Semih · North Little Rock, ARN7071WTeigen Travis S · Glenwood City, WIN7071YJts Aircraft LLC · Rock Hill, SCN7072BJenema Jerry W · Lake City, MIN7072GMears Benjamin W III · Eastville, VAN7072KElliott Troy D · Star, IDN7072LPolsin Thomas H · Lowell, WIN7072PRegistration Pending · Kalispell, MTRegistration pendingN7072QB&R Aircraft LLC · Wadsworth, OHN7072RMckinley Matthew R · Sault Sainte Marie, MIN7072WNelson David L · Laporte, IN
Back to AD 90-04-06 R1