AD 2004-08-15
Registered aircraft · 2,920
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-08-15')
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-08-15')
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-08-15') 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-08-15') 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.
N10EGJarcav LLC · The Woodlands, TXN10LYAir & Water Research Corp · Wilmington, DEN10MDMiss Blackwell Aviation LLC · Pawleys Island, SCN10PFAqua Lift LLC · Key Largo, FLN10TCGardner Aviation LLC · Hot Springs, ARN10UHUniversity Of Alabama Board Of Trustees · Birmingham, ALN10UTOut Aviation LLC · Fort Wayne, INN11007Coastal Elite Air LLC · Helena, MTN110FDYellowstone Leasing LLC · Pray, MTN110GGo Soar LLC · Highland Village, TXN110JBIngles Markets Inc · Asheville, NCN1111SStockbridge General Contracting Inc · Clovis, CAN1116RCtb Inc · Milford, INFirst renewal noticeN111AABlue Water Aviation LLC · Vestavia, ALN111AFWings Aloft Inc · Portland, ORN111BBCypress Aircraft Sales LLC · Clermont, FLN111CAKingmax Aviation LLC · Miami, FLN111ENPecos Air Inc · Roswell, NMN111FFabair LLC · Milwaukee, WIN111FWAcme Management Co · Fort Worth, TXN111GEBank Of Utah Trustee · Salt Lake City, UTN111GJMalik Hassan · Richfield, OHN111LJSourek Trail Co Inc · Barberton, OHN111MKJrnd Corp · Lewes, DEN111PVHenson Builders LLC · Dallas, TXN111SGAir Orlando Helicopters And Leasing · New Smyrna Beach, FLN111SSFamily Time Machine LLC · Stuart, FLN111YWN111yw LLC · Houston, TXN1125AAviation Trust Company LLC Trustee · Oklahoma City, OKN1127KHutter Charles G · Carson City, NVN11288Fly The Coop Aviation LLC · Willow Park, TXN112BJDg Group Aviation LLC · Bloomfield Hills, MIN112EMRegistration Pending · Las Vegas, NVRegistration pendingN112GSMldw Holdings LLC · Darien, CTN1135KQualitair LLC Trustee · MichelstadtN113BGWdc Equipment LLC · Webster, TXN113CATeton West Holdings LLC · Rcho Sta Marg, CAN113SHHill Lawrence E · Marion, MTN114CWMatagorda Production Co · Houston, TXN114VRSkyline Holdings LLC · Hailey, IDN114WBank Of Utah Trustee · Salt Lake City, UTN115CJConquest Services Inc · Santa Rosa, CAN115MEGreenwing Resource LLC · Tipton, MON1163MNew World Aviation LLC · Edinburg, TXN116ADStone Holdings LLC · Towson, MDN116KCRa Aviation LLC · Dover, DEN116MBTvpx Ars Inc Trustee · North Salt Lake, UTN116MLRegistration Pending · Coshocton, OHRegistration pendingN117BGJohnson Calvin · Fort Lauderdale, FLN117MAT&J Aviation LLC · Clovis, NM
Back to AD 2004-08-15