AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N756ZYChapa Jana K · Corpus Christi, TXN75701Roseville Aviation LLC · Roxboro, NCN75704Lanning 1 Aviation LLC · Amarillo, TXN75706Morey Airplane Company Inc · Middleton, WIN75709Newsom Richard W · East Bend, NCN7570FReichelt Christopher M · Mocksville, NCN7570HSearles Lewis A Jr · Grafton, OHN7570JHubbard David L · Earlville, ILN7570KStrub Henry J · Dillingham, AKN7570PKraule Ernest O · Saratoga, CAN7570WWatkins Andrew B · Redding, CAN7570YJackson Rex A · Granbury, TXN7570ZKingsley Kiman J · Miller, MON75710Cox Leon F · Ruffin, NCN75711Falcon Air LLC · Anchorage, AKN75712Hill David Ryan · Palm City, FLN75714Lincoln Skyways Inc · Lincoln, CAN7571GCook Thomas B · Boston, MAN7571HChristman Christopher D · Chugiak, AKN7571PScribner George W · Suffolk, VAN7571TKillebrew Elizabeth Morrigan · Round Rock, TXN7571VRothstein Tim P · Litchfield, MNN7571WCox Kevin D · Draper, SDN7571YPipers Are Still Better LLC · Carson City, NVN75721Propell Air LLC · Deridder, LAN75722Pt Real Estate Inc · Port Hadlock, WAN75724Lenamond L Don Jr · Anchorage, AKN75726Don Davis Aviation Inc · Henderson, KYN75727Silverhawk Aviation Academy Oregon LLC · Ontario, ORN7572ENibbe Douglas L · Saint James, MNN7572FKinder Mark E · Scottsdale, AZN7572HStark Jeffrey J · Fairbanks, AKN7572VOffshore Services Ltd · Block Island, RIN7572WRegistered aircraftN7572YBlack And Faraday Inc · Pencil Bluff, ARN75731Ziegler Carl F · Forest Lake, MNN75733Red Door Aviation LLC · Dover, DEN75739Entroair LLC · Hilliard, OHN7573FDirks Daniel P · Seguin, TXN7573GBecker Todd J · Arlington, NEN7573HSugden Richard M · Hallock, MNN7573KPeile Kelly · Lakeview, ORN7573PPurcell John H III · Mechanicsville, MDN7573RMonadnock Choppers LLC · North Swanzey, NHN7573VOlson Jerome W · Kerrville, TXN7573YLawrence Earl A · Alexandria, VAN75740Kingdom Air Corps · Sutton, AKN75743Aerosmith Aviation LLC · Panama City Beach, FLN75744Blue River Aviation LLC · Palmer, AKN75746C-Squared Aviation LLC · Delaware, OH
Back to AD 81-18-04 R2