AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N706BHSilver Lance Aviation LLC · Ketchum, IDN706CUsda Aphis Ws · Cedar City, UTN706CBMetal Feathers Inc · Ovilla, TXN706CFRegistered aircraftN706DAFlycarolina LLC · Charlotte, NCN706DEBradley Aircraft Company LLC · Columbus, INN706FLTime Flys Idaho LLC · Clarkston, WAN706HPFlorida Highway Patrol · Tampa, FLN706JJJj Helicopters Inc · Torrance, CAN706KSSzmania Kris J · Rossford, OHN706LA4 Winds Consulting LLC · Nashua, NHN706LGRegistered aircraftN706LULiberty University · Lynchburg, VAN706MU S Dept Of The Interior · Boise, IDN706MCSt Bernard Parish Government · Chalmette, LAN706NDUnd Aerospace Foundation · Grand Forks, NDN706QRegistered aircraftN706RAChristiansen Aviation LLC · Wilmington, DEN706RPPuckett Rex L · Silver Creek, GAN706SATextron Aviation Inc · Wichita, KSN706TGauntlett Robert Michael · Yukon, OKN706TBMha Flying LLC · Annapolis, MDN706UBMaliskey 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, TXN7071PNelson Harold G · Pendleton, ORN7071QSun 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, INN70739Morey Airplane Co Inc · Middleton, WIN7073BHerman Seth J · Brookville, PAN7073GSky Warriors LLC · Hayward, CA
Back to AD 81-18-04 R2