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.
N969TALola Cattle Co LLC · Rio Grande City, TXN96CSHeli Soar LLC · Sparks, NVN96SKRotor-Head LLC · Owasso, OKN96TSCollective Air LLC · Owasso, OKN96XWLewis Everett D · Comfort, TXN972SALindeman Inc · D'Hanis, TXN977AZMb Powers Inc · Thompsons Station, TNN977WBFlying Mermaid LLC · Aiea, HIN9786GGatwood Wesley · Sumrall, MSN978ETFlying J Services LLC · Jourdanton, TXN979RMBack Forty Equipment LLC · Cape Girardeau, MON97TKDekalb Aviation LLC · Williston, NDN97UPMf Helicopters LLC · East Troy, WIN980TTVector Group Inc · Parsippany, NJN985TMExtapa LLC · Wilmington, DEN9876JK & S Irrigation Inc · Higbee, MON987WHAlpha Aviation LLC · Anchorage, AKN988NPlane Fun Inc Tr Trustee · Snellville, GAN98VLVortex Leasing LLC · Racine, WIN991CFHelicrops LLC · Flora, ILN991CWKolibri Aviation LLC · Pacoima, CAN991TVSky Helicopters Inc · Garland, TXN992RWDown To Fly 2 Day LLC · Dover, DEN992TCSierra Heli Partners LLC · Reno, NVN992TP2t Partnership Ltd · Pecos, TXN992VAurora North LLC · Helena, MTN994KCCayton Sidney M · Aurora, NCN99519Alyeska Helicopters LLC · Girdwood, AKN99587Registered aircraftN99603Alpine Air Alaska LLC · Girdwood, AKN99605Alpine Air Alaska LLC · Girdwood, AKN99645Alpine Air Alaska LLC · Girdwood, AKN99693Alpine Air Alaska LLC · Girdwood, AKN996NRNative Range Capture Services Inc · Elko, NVNon-citizen corporation, flight hours not reportedN997SRSpitzer Helicopter LLC · Wilmington, DEN997SUSouthern Utah University · Cedar City, UTN997VAOlioni Aviation LLC · Palo Alto, CAN998MSRegistered aircraftN998TPBering Air Inc · Nome, AKN999EVJordan Helicopters LLC · Brady, TXN999PUPapa Unicorn Heli LLC · Key West, FLN999UHAlba Aviation Services Inc · Scottsdale, AZN99RRReynolds Darryl G · Wills Point, TXN99TVSky Helicopters Inc · Desoto, TX
Back to AD 95-26-05 R1