AD 80-25-07 R1
Registered aircraft · 25,370
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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.
N3262FCm&K Enterprises Inc · Brandon, MSN3263FVelazquez Carlos A · Lexington Park, MDN3263JCorrigan Air Center LLC · Hondo, TXN3264FWhite Sawyer A · Longmont, CON3264TVan Iderstyne Richard D · Jekyll Island, GAN3265ETa Brand LLC · Middletown, DEN3265FOsborne Allen Wright · Waxhaw, NCN3266EN3266e LLC · Homestead, FLN3266FStolar Michael · Washington, VAN3268CLane Ryan Auctions LLC · Palmyra, PAN3268KRegistered aircraftN3268TKawsara Sabah M · Fort Worth, TXN326AMAviatzone LLC · Fort Lauderdale, FLN3272FCarroll Daniel T · Holbrook, AZN3272TSonoras John G Jr · Newport, MIN3273EAnderson Thomas J · Big Bear City, CAN3273FRydeen Carl Edward · Little Falls, MNN3273TSommers Bradley D · Robinson, KSN3274EBitzer John · Cologne, MNN3274TRinkle Michael G · Sussex, NJN3275CMoore Hazel Grace · Boise, IDN3275FThree Chopt Flying Club · Charlottesville, VAN3277CSandstrom Mark R · Minot, NDN3279CHunsucker Michael A · Seguin, TXN327BEBlack Swamp Flyers LLC · Fremont, OHN327XNew Horizon Aviation Inc · Warwick, RIN3280FChristian Edward A · Evans, GAN3281FCapps Daniel Boyce · Newcastle, OKN3281RNowicki Stanislaw · Cottonwood Heights, UTN3282TCavu Aircraft Sales & Management Inc · Olyphant, PAN3283FMorgan Lance A · Georgetown, TXN3284FHicks Raymond K · Villa Rica, GAN3285FAir Mods And Repair Inc · Robbinsville, NJN3287EOff Course Aero Ventures LLC · Mechanicsville, VAN3287FSchaumberg John · Lebanon, INN3288FFlightbyte LLC · Wilmington, DEN3289FRubiales Mauricio A Jr · San Diego, CAN328CMSimunaci Jeffrey · Placitas, NMN328DDLandsburg Custom Services LLC · Sandusky, MIN328MDJames Douglas M Trustee · Scottsdale, AZN3291EKukuchka Ronald G · Tunkhannock, PAN3291FEvans Derek M · Fresno, CAN3292FGoodwin Darrell W · Richmond, TXN3292TCelestial Kinetics Flight Academy LLC · Waupaca, WIN3293FYe Xiaofeng · Los Gatos, CAN3294FWatkins Grant M · Durant, OKN3294TWolniansky Peter W · Ocean Grove, NJN3297FCadillac Aircraft Services Inc · Cadillac, MIN3297TBurgdorf Dale A · Plano, TXN3298T515 Aviation LLC · Dexter, IA
Back to AD 80-25-07 R1