AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N5184S1st Cooling Inc · Rockwall, TXN5184XComstock Derrick B · Salol, MNN5185DMartinez Richard Christian · Stockbridge, MIN5185QRegistered aircraftN5185TRomano Serge · Beaverton, ORN5185UMoyer Aviation Inc · Tobyhanna, PAN5185YPiedmont Flight Inc · Winston Salem, NCN51863Green Wendell L · Argyle, TXN51865Savage Michael B · Lincoln, CAN5186HPope Brian B · Coalgate, OKN5186UHumphrey Jeffrey · Corvallis, MTN5186WQuick Janice L · Wrightwood, CAN5186XRochelle Stephen L · Raymond, MSN5186YHowe Jamie W · Boynton Beach, FLN51871Az2026 LLC · Miami, FLN51875Wings Over Texas Holdings LLC · Denton, TXN5187AHada Benjamin · Andrews, TXN5187DHonnold Thomas M Jr · Cascade, IDN5187ENowak Michael J · Waxahachie, TXN5187GThompson Edward A · Sunset Beach, NCN5187JDagger Falls LLC · Boise, IDN5187LMcclelland Kip · Douglas, GAN5187RTke Ltd · Thief River Falls, MNN5187TLopes Steve R · Lancaster, WIN5187WGardner Robert E · Dixon, CAN51883Angel Aviation Inc · Peoria, AZN51885Angel Aviation Inc · Peoria, AZN5188HHartley Jerome K · Talkeetna, AKN5188LMascari Nicholas M · Mundelein, ILN5188SMiller Kaci · Bullhead City, AZN5188TCohen Edward R · Loomis, CAN5188USky Stallion LLC · Winter Park, FLN5188YElliott William R · Reno, NVN51890Hyldburg Aviation Inc · Plymouth, MAN5189ABarrymore Cole · Government Camp, ORN5189EOpportunity Flying Club Inc · Anchorage, AKN5189LMicic Miodrag · Lake Elsinore, CAN5189SBender Douglas E · Kendallville, INN5189YKmc Aviators LLC · Burlington, CTN518ABVickery Hawk Partners LLC · Fort Worth, TXN518ACGernand Charles · Hoopeston, ILN518AFAmerican Air Academy Inc · Merritt Island, FLN518APWilliams Brian K · Mattituck, NYN518BBJ S Aviation Corp · Farmingdale, NYN518BW8bravo Wiskey LLC · New Liberty, KYN518CACompass Aviation Inc · Shelby, NCN518CDCornerstone Auto Parts LLC · Pratt, KSN518CMTreakle Robert W · Austin, TXFirst renewal noticeN518CRM & A Aircraft LLC · Wilmington, DEN518DPN518dp LLC · Spruce Pine, NC
Back to AD 2007-04-19 R1