AD 99-01-05 R1
Registered aircraft · 10,639
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:99-01-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:99-01-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:99-01-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:99-01-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.
N1820ACaley Robert M · Green, KSN1823PGranger Joshua M · Rosebud, MTN1827PMechel Emil C · Toledo, OHN1829AMcelligott Joseph P · Ione, ORN1829PBoll Ryan C · Sheboygan, WIN1830AMurphy Joshua T · South Lyon, MIN1830PRegistered aircraftN1831PFay Bernard E · Eagle, AKN18338Carpenter Jeff D · Fairbanks, AKN1833PJones Brian K · Scituate, MAN1834PHellyer James R · Darien Center, NYN1835PVintage Restorers Ltd LLC · Windsor, CON1836ABhl Aviation LLC · Denver, CON1838AGray Shane Charles · Interlochen, MIN1838PLarsen Steve J · Colton, ORN1841AJohnson Kevin L · Canyon, TXN1843PAdams James · Quinlan, TXN1846PGrumpy Aviation Ltd · Denver, CON184WFSitkiewicz James P · Anchorage, AKN184WLNastro Kristopher J · Fallon, NVN1850AWells Kris G · Barron, WIN1850PPeters Nicholas J · Eagle River, AKN1852PBennack George H · Lyford, TXN1853DBent James L Jr DBA · Palatine Bridge, NYN1853PViersen Leonard J Trustee · Glennallen, AKN1855AMoore Brandan D · Wasilla, AKN1857PJanvrin Jerry M · Buffalo, SDN1858ALow And Slow LLC · Bozeman, MTN1861ABernstein Timothy D · Faith, SDN1869ATiberius Rex Aviation LLC · Carson City, NVN1869WWolter Kenneth W · Wasilla, AKN186TKing George W · Strykersville, NYN1871ASkywagon Aero LLC · Wilmington, DEN1876AKalarney Kerry T · Olathe, CON1878ANapa Taildraggers Inc · Napa, CAN1878PLutter Jim L · Gann Valley, SDN1879ASale Reported · Eagle River, AKSale reported, pending cancellationN1879PWbs Coatings Inc · Grand Junction, CON1880PSt Jean Kurt Joseph · Homer, AKN1882PAir Dakota Flite Inc · Hettinger, NDN1883PDavis Tom C · Belle Fourche, SDN1884PStoica Michael J Jr · East Liverpool, OHN1886AGriffith Richard B · Sycamore, ILN1886PAlligood Allen K · Wasilla, AKN1887AErickson Paul F · Wasilla, AKN1888AAlaska Tailwheel LLC · Fairbanks, AKN1889PVeatch William E · Hood River, ORN1890AJohnson Air LLC · Anselmo, NEN1890PParker Paul R · Summit Point, WVN1891AEntriken Birch N · Reno, NVFirst renewal notice
Back to AD 99-01-05 R1