AD 72-03-03 R3
Registered aircraft · 17,027
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:72-03-03-R3')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
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:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') 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.
N2925XPerry Albert D · Houston, TXFirst renewal noticeN2925YTrinity Air LLC · Lewes, DEN2926SFord John M · Rock Stream, NYN2926YViramontes Gilbert A · Temple City, CAN2927YReynolds Nathan W Jr · Piedmont, SCN29289Disarro Wayne · Wasilla, AKN2928JVu Huy T · San Diego, CAN2928SDoubler Endeavors LLC · Orlando, FLN2928YDiamond X LLC · Elko, NVN29292Skytime Aviation LLC · Tulsa, OKN29299Svetic Russell T · Redondo Beach, CAN2929FSmith Lane R · Lewistown, MTN2929STerrell Aviation Inc · Terrell, TXN2929XKot Ronald J · Punta Gorda, FLN292DAIndependence Youth Flying Club Inc · Independence, ORN29307Lacroix Michael G Trustee · Shorewood, MNN2930FWrucke Scott · Horicon, WIN2930JTetil Nicholas M · Fairgrove, MIN2930XAero Dynamics Flying Club Inc · Mulino, ORN2931JSmith William T · Fort Payne, ALN2931XRegistered aircraftN2931YWiesner Norman P Trustee · Silverton, ORN29320Triple G Aviation LLC · South Point, OHN29321Render Jeff · Peoria, ILN29329Hill Edward J Jr · Dover, DEN2932SRutoski Mary Ann · Jordan, MNN29330Rucinski Edward A · Climax, NCN29334Burger Cale L · Hampden, MEN29335Sale Reported · Lebanon, ORSale reportedN2933FLevinsohn Reuben D · East Lansing, MIN2933SHarry Kevin M · Salisbury, NCN29340Hodges Michael T · Myrtle Beach, SCN29343Aeromech Incorporated · Mukilteo, WAN29344P & P Aviation LLC · Trout Run, PAN29345Bailey Daniel L · Gibsonville, NCN2934FH & S Aviation LLC · Roseville, MNN2934YOwens John A · Granville, OHN29350Cardinal Flyers LLC · Amherst, VAN29356Rohwer Celia · Fairbanks, AKN2935FPeirce Brenden D · Eatonville, WAN2935JSmith Stanley P · Athens, ALN2935XStelzer David C · Vermilion, OHN29362Registered aircraftN29366Bond Joseph C · Arlington, TXN29367Dulin Jim · Valparaiso, INN2936JElkins James D · Salem, ORN29377Duncan John M · Owingsville, KYN29379Sattler Russell P · Brooksville, FLN2937JSchumann Jennifer Pauline · Conroe, TXN2937YSkylane Inc · Moose Lake, MN
Back to AD 72-03-03 R3