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.
N601PEVcs Transportation LLC · Hampton, VAN601PSCastle Rock Services LLC · Helena, MTN601PTWf Aviation LLC · Bozeman, MTN601PZSkyking Aviation Services LLC · Carson City, NVN601RDPichon Dean M · Essex, VTN601RKNorthampton Aeronautics Inc · Northampton, MAN601RVFly Right LLC · Reno, NVN601TGKenmore Crew Leasing Inc · Bellingham, WAN601TMMims Edwin T · Murphy, NCN601TTAgee John M Trustee · Sunriver, ORN601VLBeal Mark E · Northwood, IAN601VSJireh Wings LLC · Las Vegas, NVN601VVBilodeau Allan M · Lakeland, FLN601XSSpainhower Craig · Lakeland, FLN6020DDufreche David S · Sanger, TXN6020F7l Air LLC · Franklin, TXN6020LJenkins David B · Hemet, CAN6020PClark Katherine A · Spring, TXN6020QN6020q LLC · Jensen Beach, FLN6020WBritton Jeffrey A · Accident, MDN6021FB R S Leasing Inc · Wilmington, DEN6021KRegistration Pending · Grand Forks, NDRegistration pendingN6021MPark Rapids Avionics Inc · Park Rapids, MNN6021QR&L Aviation Inc · Philadelphia, PAN6021WA&C Aviation LLC · Lawrenceville, GAN6021ZAerial Banners Inc · Pembroke Pines, FLN6022LIrving Donald J · Deland, FLN6022PRegistered aircraftN6022SAhlberg Merick D · Eagle River, AKN6022WDelgado Mario J · Baldwin Park, CAN6023AKirkendall Shane O · Cedar Park, TXN6023DBusta Daniel N · Los Angeles, CAN6023SChristiansen Aviation LLC · Wilmington, DEN6023VChristiansen Aviation LLC · Wilmington, DEN6023XSytsma Douglas A · Canton, MIN60244Ace Of Spades Aviation LLC · Las Vegas, NVN6024DPunt Matthew L · Wasilla, AKN6024EDhs Operations LLC · Wilmington, DEN6024TDouglass Bruce · Conway, MAN6024WWhite Pelican LLC · Union City, TNN60250Camelot Aviation LLC · Wilmington, DEN6025DMorgan Joel E · Mcalester, OKN6025WSocal Flights LLC · Simi Valley, CAN6026CPflueger Michael W · Scottsdale, AZN6026GAce Pdr LLC · Lewisville, TXN6026LDolan Kathleen M · Sunnyside, WAN6026QKosmata Charles C · Mcpherson, KSN6026SPhoneix East Aviation LLC · Daytona Beach, FLN6026ZAerodynamic LLC · Aurora, ORN60279Tensco Inc · Twin Falls, ID
Back to AD 81-18-04 R2