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.
N5159DFleming James Daniel · Kansas City, MON5159HH&H Restoration LLC · Wasilla, AKN5159MThunder Wings LLC · Wilmington, DEN5159NO Bleness Kevin W · Bethel, AKN5159RBackcountry Adventures LLC · Big Lake, AKN5159SDupre Richard H · Newton, NHN5159UPostolnikov Paul V · Graham, WAN5159WZvirzdinis Jeffrey J · Lowell, MIN515AJDantonio Alfred · Tallahassee, FLN515AKHigh Mark Aviation LLC · Enid, OKN515BBQuad B Flying LLC · Mitchellville, IAN515CLProfessional Pilot Services LLC · Miami, FLN515DCmmk LLC · Talent, ORN515DBSmith Christopher Robert · Snowflake, AZN515DGGatlin David T · Wickenburg, AZN515EDBlue Sky Pilots Inc · Salem, ORN515FVSlowmow Inc · Palestine, TXN515HWade Robert L · Orchard Park, NYN515JAMuhle Paul M · Columbus, NEN515JDSmith Michael K · Grass Valley, CAN515JFMedtek Inc · Racine, WIN515JHA&J Aircraft Leasing Inc · Burlington, CON515KCDeland Michael · Irvine, CAN515KGBatsche George M · Tampa, FLN515KPKading Air LLC · Urbandale, IAN515MAAdams Scott M · Seabrook, TXN515MBMoxie Air LLC · Winston Salem, NCN515MDPodlesny Joseph F Jr · Glenmoore, PAN515MSDraco Flight School DBA · Chino, CAN515PDSeals Welding & Fabircating Inc · Oxford, ALN515PJKinsey Michael · Colorado Springs, CON515PUAviation Trust Co LLC Trustee · Oklahoma City, OKN515RDWings Over Texas Holdings LLC · Denton, TXN515RJFroehlich Franz M · Oceanside, CAN515RRHangar 49 Ltd · Wilmington, DEN515RTCemco Industrial Park LLC · Belen, NMN515SRegistration Pending · Azle, TXRegistration pending, pending cancellationN515SDHoma Alex Michael · Ozark, ALN515SED & H Equities LLC · Helena, MTN515SKTurner Jereme K · Marietta, GAN515SPFriedlander Ernest · San Francisco, CAN515SRGifford Daniel · Fredericksburg, TXN515STQ&A Holdings LLC · Elkridge, MDN515TGMilton Steven Pichon · Houston, TXN515TLLumpkin Theodore G III · Inglewood, CAN515TMKrotje Benjamin · Wills Point, TXN515TRRabaut Charles P · Oceanside, CAN515UDTumbleweed Leasing Company Inc · Salt Lake City, UTN515VTBud E Aero Inc · Franklin Square, NYN515VVGolden Age N515vv LLC · Norwalk, IA
Back to AD 2007-04-19 R1