AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N48KCGraham Norman J · West Ossipee, NHN48KLMills Kenneth J · Fort Mill, SCN48KSHolcomb Garry M · Point, TXN48KUWildcat Aviation LLC · Wilmington, DEN48LEFerguson William T · Fayetteville, TNN48LFKraxberger Scotty L · Salida, CON48MGarrison William E · Nickerson, KSN48MBCaddell Charles Thomas · Wadesboro, NCN48MHSeventh North Hangar LLC · Bolton, MAN48MMDierks Herman D · Round Rock, TXN48MWFour Echo X-Ray LLC · Boston, MAN48NGSterling Air Inc · Little Rock, ARN48PFFree Philip O · Collierville, TNN48PKWoodward Daniel S · Springville, UTN48PMFreeman Robert G DBA · Baker, FLN48PRBadrow Allan R · Warrenton, VAN48RDMiller Montgomery A · Carmel, INN48REMountain Tide LLC · North Bend, ORN48RGBlueskies LLC · Smyrna, TNN48RKKinnischtzke Lyle V · Mandan, NDN48RPClark Mitchell J · Parker, CON48RSColin A Oerton · Miami Beach, FLN48SSiragusa Pamela L · Cypress, TXN48SJJohnston Stephen P · Hawley, MNN48TIndian Springs Cattle Co Ltd · Wilmington, DEN48TDFoster Aviation LLC · Missoula, MTN48TXCulater LLC · Indianapolis, INN48TZVisibility Unlimited LLC · Carbon, INN48VAGeiser Corbin · Little Elm, TXN48VZPrecision Jet Service Inc · Stuart, FLN48WCBaron Acquisition LLC · Wayne, PAN48WEAircraft Guaranty Corp Trustee · Oklahoma City, OKN48WFEarlybird Aerial Services LLC · Goodfield, ILN48WLAtkinson Matthew D · Theodore, ALN48WMCalcaterra Paul · Okeechobee, FLN48WWSupercub Aviation LLC · College Station, TXN48WYTyphoon Products Inc · Umatilla, FLN49007N49007 LLC · Wasilla, AKN4900ABaum James L Trustee · Anchorage, AKN4900CRider Bradley H · Juneau, AKN4900JUniversal Technical Institute Inc · Avondale, AZN4900URegistration Pending · Rockville, MDRegistration pendingN4901ASchneberger C J · Clinton, IARevoked, canceledN4902ACavanagh Michael B · Dubois, WYN4902FFlying Vikings Inc · Hayward, CAN4902LObrien William M · Aptos, CAN4902RBecker Flying Service Inc · Hartington, NEN4902SBbsa Flight LLC · Tucson, AZN4902UWallace Randall · Stamps, ARFirst renewal noticeN4903AKendall Ted O · Lakeside, CA
Back to AD 2007-04-19 R1