AD 95-26-05 R1
Registered aircraft · 1,944
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:95-26-05-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:95-26-05-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:95-26-05-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:95-26-05-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.
N555VUOut On A Limb Tree Service LLC · Arlington, WAN557SMAcmeflight LLC · Santa Rosa, CAN558WManticore LLC · Alton, NHN559BDBiggs Aviation LLC · Decatur, INN559RKRegistration Pending · Sheridan, WYRegistration pendingN55HVAircraft Guaranty Corp Trustee · Oklahoma City, OKN55PVHeli Munnik LLC · Springfield, MON55TPMyers Dwayne L · Newcastle, WAN560EHSafeflightops LLC · Venetia, PAN562TSumner Properties LLC · Somersworth, NHN566NHDiliji Enterprises International LLC · Albuquerque, NMN5678JOuroboros LLC · Missoula, MTN567HATj Helicopters LLC · Seymour, TNN567PBNorthbound LLC · Wasilla, AKN567PWMasok Air LLC · Los Angeles, CAN567SHSpitzer Helicopter LLC · Wilmington, DEN569CDDgt Aviation LLC · New Bern, NCN569DWBranched Oak Charter LLC · Rising City, NEN569PKWorld Aircraft Inc · Wagener, SCN569TLRotermund Brett L · Fairbanks, AKN56BEBirds Eye View Inc · Middletown, RIN570GGGlenwood Farm LLC · Edgerton, MON570HRegistered aircraftN570WHMf Helicopters LLC · East Troy, WIN571WCJewell Scott M · Willow, AKN572BCT & D Ironhorse LLC · Tampa, FLN577BASpitzer Helicopter LLC · Woodland Hills, CAN578SAAircraft Guaranty Corp Trustee · Oklahoma City, OKN579DGCulver Lane M · Laceys Spring, ALN57BAHelicrop LLC · Menlo, IAN583CTDog & Bear LLC · Longboat Key, FLN583TYGolden Bullet LLC · Naples, FLN584ABSmith Helicopters Inc · Cotulla, TXN584CCHeliflights Leasing LLC · Brick, NJN584RHMile High Rotors Inc · Indian Hills, CON585GGJoey Os LLC · Darlington, PAN586TSUniversity Of North Dakota · Grand Forks, NDN587DEAlpine Air Alaska LLC · Girdwood, AKN588SFIntrepid Helicopters LLC · Sylvania, OHN58LEVeracity Aviation LLC · Seguin, TXN58SESky Solutions LLC · Westland, MIN58UHFrontier Helicopter Service LLC · Anchorage, AKN58UPOur 44 Inc · Corralitos, CAN590GGSur Andrey · Alpharetta, GAN590HMclane Ryan · Central Point, ORN590HSMueller Aviation LLC · Austin, TXN590VMHutchings Kimberly · Campbell, TXN594KRWombat Aviation LLC · Cedar Park, TXN595GGMoon Air Inc · Albany, KYN59FDPollux Aviation Ltd · Wasilla, AK
Back to AD 95-26-05 R1