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.
N424ACGilliam Robert L · Clinton, TNN424ADSky West Aviation Inc Trustee · Albuquerque, NMN424AKMcgregor Thomas M · Chugiak, AKN424BDBadass Aviation LLC · Fernandina, FLN424BWSkye Equipment LLC · Asheboro, NCN424BYSkyline Soaring Club Inc · Front Royal, VAN424CBLesnett Robert G · Novato, CAN424CHFlying Betty LLC · Prescott, AZN424CRS&S 1165 Investments · Wimberley, TXN424DDMaple Aviation LLC · Big Fork, MTN424EChristiansen Aviation LLC · Wilmington, DEN424EGS&R Flying LLC · Franklin, TNN424EPLuxury Helicopters Of South Florida Inc · Hollywood, FLN424FLNeihart Randy L · Fontana, CAN424FPUtah State University · Logan, UTN424GCVandent Aviation LLC · Wilmington, DEN424JN424 Juliet LLC · Mesa, AZN424JBJsj Aircraft Holdings LLC · San Diego, CAN424KCCoontz James K · Melba, IDN424LEckberg Robert K · Dakota City, IAN424LLLarkin Michael Paul · Port Orange, FLN424MEKfl LLC · Canyon Country, CAN424MROsborne Clarence Michael · Madison, MSN424NTLattin Travis · Beloit, KSN424PASkywest Leasing Inc · St George, UTN424PCMontana Livestock Ag Credit Inc · Helena, MTN424PEUniversity Of Alaska Anchorage · Anchorage, AKN424PSRegistered aircraftN424QLj Sutter Aviation LLC · Shavertown, PAN424RDTorin Thomas Roschinger · Anchorage, AKN424RHRegistration Pending · Ogdensburg, WIRegistration pendingN424RNKraut Brian J · Green Cove Springs, FLFirst renewal noticeN424RWWestphal Jon A · Menomonie, WIN424SCThread Head Quilting LLC · Anchorage, AKN424SEOliveira Jean Alves · Bedford, MAN424SFJets To Helis LLC DBA · Chandler, AZN424SHLeading Edge Aviation Inc · Bend, ORFirst renewal noticeN424SPPft Inc · Wilmington, DEN424STMisto Louis III · Westerly, RIN424SVLow Randall Brett · Antlers, OKN424TFHalf Penny Hangar Inc · Houston, TXN424TRCovin Equipment LLC · Arlington, TXN424WSkywarrior Flight Training LLC · Pensacola, FLN424WGClement Victor T · Ord, NEN424WMMorrison Jeffrey A · Williamson, GAN424WTLumberton Air 1 LLC · Mount Laurel, NJN4250Leafgreen Jeff A Trustee · Lander, WYN42502Stackhouse Mark A · Orwell, OHN42504Dent Michael Otha · Lake Wylie, SCN42508Sher Lease LLC · Pelican Rapids, MN
Back to AD 2007-04-19 R1