AD 91-22-01
Registered aircraft · 1,525
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:91-22-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:91-22-01')
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:91-22-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:91-22-01') 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.
N15TBEast West Helicopter Inc · Batesville, INN1609XHarvey P J · Midland, TXN163CLJust Saying Construction LLC · Merritt Island, FLN1651XPeters Mark E · Newport News, VAN1656XAnderson George E · Newnan, GAN165WFHardin John M · Terrell, TXN1696XCenturion LLC · New Bern, NCN1698XCmo Blue Sky LLC · Tomball, TXN1716XBell Brian · Oakland, CAN171KSVida Vibrante LLC · San Juan, PRN1720XKregel Brian D · Garnavillo, IAN1724THanna David B · Tonasket, WAN1734XRight Wing Left Wing Flyers LLC · Cleveland, GAN173MCCiochetti Michael J Jr · Clayton, GAN1744XDodson International Parts Inc · Rantoul, KSN1748ZRanz Douglas R · West Bloomfield, MIN1754XWest Alabama Lime Co Inc · Livingston, ALN1763XRobins Nest Aviation LLC · Harrison, OHN1764XLeschber Larry · Hutto, TXN176LLClear Above LLC · Haymarket, VAN1770XPark Avenue Group Inc · Stuart, FLN1778MSeitz David C · Gordonville, TXN1794XGulf Atlantic Airways Inc · Gainesville, FLN1797XN1797x Aero LLC · Gulf Breeze, FLN1798XN1798x LLC · Etna Green, INN17ABBas Part Sales LLC · Greeley, CON17HSRed Oak Centurion LLC · Red Oak, IAN17JYYorkavitz James B · Valley City, OHN17TCKenyon Walter C · Eureka Springs, ARN1800FReid Brian M · Boise, IDN1801ZGould Robert R Jr · Sterling, VAN1802FSantiago Ferdinand · Calhoun, GAN1802ZSparks Timothy J · Jackson, MIN1804FWaage Todd · Greenbush, MNN1808ZFlanagan Enterprises (Nevada) Inc · Zephyr Cove, NVNon-citizen corporation, flight hours not reportedN1809ZCleared For Departure LLC · Kennewick, WAN1810ZRanzway Corp · Seattle, WAN1814FAlpine Cable And Construction Inc · Grand Junction, CON1816FMalcom Scott O · Toledo, WAN1820ZStaats Douglas E · Anchorage, AKN1821FAlexander Travis · Hudson Oaks, TXN1821SBailey Ralph E · Sikeston, MON1822ZAhrens Kevin Michael · Cashmere, WAN1825ZGreentek Inc · Oroville, CAN1828FDrew Kevin · Fredonia, PAN1828ZHorrocks Charles M · Blackfoot, IDN1833FHale Jay · Corpus Christi, TXN1833ZEastwood Gregory S · Red Oak, TXN1835ZRegistered aircraftN1838ZAgee Mark L · Greenacres, WA
Back to AD 91-22-01