AD 2004-01-05
Registered aircraft · 870
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:2004-01-05')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-01-05')
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:2004-01-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-01-05') 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.
N142LXDavidson Robert M · Incline Village, NVN146EXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN147CJCarlisle Capital Corp · Portsmouth, NHN1492JTvpx Ars Inc Trustee · North Salt Lake, UTN14GDGg Aircraft LLC · Princeton, NJN14NAAnschutz Corp · Englewood, CON150KMCcn Aircraft Holdings LLC · Portland, MEN1549ERegistered aircraftN15BYJetmax Associates LLC · Miami, FLN161MDConny Innovation LLC · Alliance, OHN167ATAai Aviation Inc · San Diego, CAN167YTriangle Mountain Partners LLC · Newark, DEN16NFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN16XYPareto Peak LLC · Salt Lake City, UTN176CG78 Aviation LLC · Oyster Bay Cove, NYFirst renewal noticeN181GD330am Holding Corp · Miami, FLN1828SRegistered aircraftN1836PTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN183WWW & W 61/63 LLC · Boca Raton, FLN1875KHcrh LLC · Louisville, KYN187AAAnton Air LLC · Las Vegas, NVN1897SJ M Smucker Co · Orrville, OHN18CGCorning Inc · Corning, NYN18MZMountainair LLC · Aledo, TXN18WQShort Hills Aviators LLC · Morristown, NJN1900BPhh Leasing LLC · Dallas, TXN190SADodson International Parts Inc · Rantoul, KSN1921ACondor Sky LLC · Chicago, ILN1922GGranite Construction Inc · Watsonville, CAN1924PN995dp LLC · New Castle, DEN1925Rheem Manufacturing Co · Atlanta, GAN1929YFalcon084 LLC · Wilmington, DEN192HAWhite Diamond Row LLC · Hackett, ARN192RSR&S Aviation Inc · Rancho Cucamonga, CAN1937VHpcc Aviation LLC · Greeley, CON195KCKansas City Life Insurance Co · Kansas City, MON195SVBank Of Utah Trustee · Salt Lake City, UTN1960HRegistered aircraftN1978GGig Air LLC · Atlanta, GAN197DXPnc Bank Na · Boise, IDN1982CCigna Holding Co · Windsor Locks, CTN1988SMckinney Vehicle Services Inc · Brea, CAN198SSSuper Flight 98 LLC · Nashville, TNN1JKPegasus South LLC · New Orleans, LAN1NCRegistered aircraftN1VMChildress Klein Management Services LLC · Charlotte, NCN2000LMl Fare LLC · Newark, DEN2000RN37hk LLC · Fayetteville, ARN200CHAllegiance I LLC · Columbus, OHN200CRRomana Aircraft Inc · High Point, NC
Back to AD 2004-01-05