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.
N370KHDuffy Edward C · Bismarck, NDN370MDAlmost There Air LLC · Daytona Beach, FLN370MEFlying Circuss Aviation Services Inc · Wasilla, AKN370MKNorth Star Aviation Inc · Mankato, MNN370PAMmm Equities LLC · Navasota, TXN370RAmerican Aircraft Management LLC · Irving, TXN370SNesbit Stephen W · Hemphill, TXN370SPElite Approach LLC · Chesterfield, MON370TBellas Business LLC · Kalispell, MTN370TCD & J Aviation LLC · Apopka, FLN370XPMckerney Charles A · Anchorage, AKN371Spengler Holdings LLC · Salt Lake City, UTN3710DHiller Paul D · Grafton, OHN3710KBlack Dragon87 LLC · Milford, CTN3710UFollette Aviation LLC · Scottsdale, AZN3710WPdr LLC · Royal Palm Beach, FLFirst renewal noticeN3711Gratech Management LLC · Washington, NCN3711NBay Area Concrete LLC · Hayward, CAN3711PN8498n LLC · Moore, OKN3711WMccaul Benjamin · San Luis Obispo, CAN3711XMoore Jerry F · Browns Summit, NCFirst renewal noticeN3711YAero Venture Lc · Shreveport, LAN37126Robison Charles T · Pierre, SDN3712PPtl Endeavors LLC · Deland, FLN3712QThomas Gregory O Trustee · Derby, KSN3712RMcbride Charles E · Omaha, NEN3712UVarian Dennis D · West Lafayette, OHN3712YRpx Technologies Inc · Stillwater, OKN3713DHedgecock David H · Elkhorn, WIFirst renewal noticeN3713K3713 Kilo LLC · Athens, GAN3713QAirborne Adventures LLC · Clive, IAN3713UDaggy Curt L III · Red Bluff, CAN3713WRvn Trucking LLC · Tilden, NEN3713ZVysoky Jessica L · Edwardsville, ILN3714DZombo Brian T · Youngsville, NYN3714NFerguson Michael D · Mendon, MIN3714USchaffer John Paul · Prior Lake, MNN3714XBig Bend Community College · Moses Lake, WAN3714YReichelt Mark C · Big Sandy, MTN3714ZQuick Foam Insulation LLC · Lubbock, TXN3715BNova Jets USA Corp · Orlando, FLN3715CHangar Ten LLC · Westfield Center, OHN3715JSmoot Nathan · Fairbanks, AKN3715NHeiderscheidt Cory L · Sleepy Eye, MNN3715PSeeley Edward J · Las Cruces, NMN3715QShellington Justin R · Columbus, NJN3715XBig Bend Community College · Moses Lake, WAN3715ZThomas Michael D · Dallas Center, IAN3716MAmbler Robert L · San Diego, CAN3716POsburn Christie R · Kotzebue, AK
Back to AD 2007-04-19 R1