AD 94-05-05 R1
Registered aircraft · 26,230
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:94-05-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:94-05-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:94-05-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:94-05-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.
N8744SZiegler Jeffery A · Crescent Springs, KYN8745GWildcat Aviation LLC · Schoolcraft, MIN8746BHeffron Jacob L · Little Falls, MNN8747SEast County Communications Inc · Hurricane, UTN8747URegistration Pending · Indio, CARegistration pendingN8748BOstby Larry · Froid, MTN8748SJones Joel K · Summer Shade, KYN8749SHart Richard G · Stoneham, MAN8749UHendrickson Flying Service Inc · Rochelle, ILN8750BLawson Winston P · Hillsboro, OHN8750GMoe Charles E · Rosebud, SDN8750UHenryetta Airman Inc · Morris, OKN8751GCrotts Joseph D · Mocksville, NCN8752UFarm Air Corp · Hoxie, ARN8753USowash Allan D · Ontario, OHN8754BFoster Steven M · Pekin, ILN8755BBurton Mark L · Lebanon, OHFirst renewal noticeN8755UDouglas-Carter Tammi A · Greenville, KYN8757SManna Anthony G · Hanover, MAN8757ULewis County Flying Club · Lewistown, MON8759SCrowell Jeremy M · Arlington, WAN8759UKelly Cynthia · Sealy, TXN875EZVon Szilassy Peter · Fredericksburg, VAN875MAGould Norman L Jr · Saunderstown, RIN8760BManaged Aviation Inc · The Villages, FLN8760UReid Gary M · Medford, ORN8761USmith Dustin T · Jasper, GAN8762UBelli Christopher J · Oregon, OHN8763BMellen Roger B · Roseburg, ORN8763GElliott Norman C · Stillwater, OKN8763SClinton Richard C · Fair Oaks, CAN8765URebel Metals LLC · Croydon, NHN8766GGascho Wendell M · Bridgewater, VAN8768UWright Roland P · Detroit, MIN8769GHeli Thrills LLC · Wills Point, TXN876WFries Jeffery A · Paw Paw, MIN87710Spencer Farm Service Inc · Taylorsville, KYN87713Eller Robert C · Glendo, WYN87714Deason Harold W Jr · Killen, ALN8771SGillette Robin A · Scio, ORN87721Majure John K · West Monroe, LAN8772SMccormick Joel S · Elmwood, ILN87734Flugzeug LLC · Hanover, INN8773GWhite Jules W · Wichita, KSN8773URegistration Pending · Scotch Plains, NJRegistration pendingN8775BGauger Cody · Edmond, OKN87776Roberts Alec · Boulder, CON8777BBurks Danny E · Fordland, MON87784Nelson Vanessa · Portland, ORN8778BJohnson Timothy L · Berlin, WI
Back to AD 94-05-05 R1